Mysql many to many selecting data - possible?

Vote count:

0

I have 2 tables that gets joined in a 3 table, so that there is a many to many relationship, and I am trying to get all users and show them once, but with all the users user groups

Users
- user_id
- email

groups
- group_id
- broup_name

users_groups
- users_groups_id
- user_id
- group_id

I am trying to get all the users and display each user once, but with all the users user groups, like shown here:

some@user.dk - admin, moderator, public
another@user.dk - moderator, public

Is it even possible to select the data like this or do you have to sort it in the code instead?

asked 2 mins ago

user1277041

3