no, you don't need a foreign key in the users table.
the keys are in the userprojects table.
the userprojects table is used to create the user to projects relationships.
this is similar to the items and genres concept from the Mage relational Data tutorial:
http://www.webassist.com/community/tutorials/view_tutorial.php?tid=25