What is the best way to organize this on your site?

Question

PHP

I want to organize groups of people on my site so that everyone can enter / exit, create / delete their own groups, the database has standard columns: id, login, password, avatar, email ..., now I have to create 2 more tables, one a table with values: group id, avatar, and a table users of groups with values: user id, login, avatar and id of the group in which he is a member. For example, when a user clicks the join a group button, the group id is written to the database, I hope I'm digging in the right direction?

Answer 1

1) Users table
2) Groups table
3) User_group table for many-to-many binding