I have a table that logs a user's id and user's name. I want to create a second table that creates a group of different users such that the table columns look like: groupname, user1, user2, user3, user4, user5, user6. I want to reference the user columns (1-6) as a foreign key to the first table's user id column as a primary key. I am using phpMyAdmin on a local server. Can this be accomplished?
EDIT:
A user shouldn't be able to belong to multiple groups, and I was thinking I could set the referenced user columns as null until a user joins the group at which point the primary-key user_id would load into the referenced user_id columns.
