User order by role spatie laravel

$values = Team::query()
      ->leftJoin('users', 'users.team_id', '=', 'teams.id')
      ->leftJoin('model_has_roles', function ($join) {
          $join->on('model_has_roles.model_id', '=', 'users.id')
               ->where('model_has_roles.model_type', '=', 'appModelsUser');
      })
      ->leftJoin('roles', 'roles.id', '=', 'model_has_roles.role_id')
      ->orderBy('roles.name')
      ->get();

Source: coderedirect.com

Similar codes

0 vote348 views2 answers
Include external php file in html
PHP
1 vote351 views2 answers
DeleteAll cakephp 2
PHP
0 vote280 views1 answer
How to unpack the html code encrypted with php curl
PHP
4 votes341 views2 answers
How to rename a table element in laravel
PHP Laravel
3 votes355 views2 answers
Wordpress get template url
PHP Wordpress
0 vote454 views2 answers
Laravel collection remove duplicates
PHP
0 vote305 views2 answers
Codeigniter 4 limit query
PHP
0 vote342 views1 answer
Régler l’enregistrement automatique dans WordPress
PHP
1 vote284 views1 answer
Get the category wp
PHP
3 votes357 views1 answer
Laravel RuntimeException Session store not set on request.
PHP