I have this basic database model I would like to group all users by role name i.e. I want to list the users who are admins and the others in two collections.
Database model
I tried to do this but it only works for one to many relationships
User::with('roles’)->get()->groupBy(‘roles.name’);