One advantage of using user_id on both the pk of users as well as the fk side is you can do:

    INNER JOIN comments USING (user_id)

instead of:

    INNER JOIN comments ON comments.user_id = user.user_id