Can't figure out structure to use

[Aggressive]

I want to have a list of clients (id, name, URL, email) and users (id, name, email) can "Register" to MULTIPLE clients.

Then I want a page to display my current Clients and under each Client is a list of users that have registered to each client, and users can be registered to many clients.

EXAMPLE:-----------

Client 1
- dan
- max
- tedd

Client 2
- max
- sarah

- tedd

I can't think of the best way to setup my mysql tables.

First I had a clients table and a users table (i intend on using my phpbb user table btw) but i ran into trouble trying to logic out the structure for multiple users being able to register under multiple clients.

[Piranha]

Use one table between them to get the many-to-many relationship. then you would have a table clientusers (clientid, userid).

But you should think twice about the design of the database, can a user be a client as well? Or is it even the case that a client have to be a user as well?

In any case you might want to reduce redundance by linking the clients and users table, that way avoiding problems if for example a user changes his email.

[bastien]

group_table
group_id
group_name

users_table
user_id
user_name

users_groups_table
user_id
group_id

users_groups_table uses a compound key of user_id & group_id