...
  INSERT INTO profile user_id values (new.user_id);
  ...

##</code><code>##

  ...
  INSERT INTO profile (user_id) values (new.user_id);
  ...