Laravel Grouping Many to Many relationships

Asked Dec 30 '21 at 05:21

Active Dec 30 '21 at 06:50

Viewed 156 times

I have 2 tables

Users :  
id
name

Roles :
id
name

These two tables have a many to many relationship with the pivot table

Role_user : 
role_id
user_id

How do I group all users by role name? I tried this but it seems to work only for one to many relationships

User::with('roles')->get()->groupBy('roles.name');

edited Dec 30 '21 at 06:50

asked Dec 30 '21 at 05:21

*How do I group all users by role name?* What do you mean? return users list as one CSV for each group? return users sorted by groups? something else? – Akina Dec 30 '21 at 05:28
For example I want to group users who are admins on one hand and users with a normal role on the other hand – Ahmed Ibrahim Meraneh Dec 30 '21 at 05:35
then you may use the Role model instead of User model for that – Jerson Dec 30 '21 at 06:38
@jerson look at the image – Ahmed Ibrahim Meraneh Dec 30 '21 at 06:51
so you mean that user will be group by many role? – Jerson Dec 30 '21 at 07:02
Yeah that's exactly it – Ahmed Ibrahim Meraneh Dec 30 '21 at 07:15
As a lot of other questions I read, it's not possible in Eloquent. You'll have to get the data and then use a loop over them to group. You can check: https://laracasts.com/discuss/channels/eloquent/laravel-5-group-by-relationships-column OR https://stackoverflow.com/questions/36468759/laravel-grouping-by-eloquent-relationship – Siddharth Bhansali Dec 30 '21 at 09:15
use `groupBy` before `get` function. – Faizan Ali Dec 30 '21 at 09:21
yet this request works for one to many relationships `User::with('role')->get()->groupBy('role.name');` – Ahmed Ibrahim Meraneh Dec 30 '21 at 09:32
It's answered here [https://stackoverflow.com/questions/70549220/how-to-groupby-many-to-many-relationships-in-laravel](https://stackoverflow.com/questions/70549220/how-to-groupby-many-to-many-relationships-in-laravel) – Oluokun Kabir Adeshina May 29 '22 at 03:59

0 Answers0