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

1 vote148 views1 answer
Php hash password using bcrypt
PHP
16 votes202 views4 answers
Carbon diffforhumans
PHP
0 vote141 views1 answer
Codeigniter update query return value
PHP
0 vote178 views1 answer
Laravel use model inside blade
PHP Laravel
0 vote185 views1 answer
Redirect all request to public folder laravel htaccess
PHP Laravel
-1 vote103 views1 answer
Strcasecmp in php
PHP
0 vote189 views1 answer
Symfony append to file
PHP
0 vote150 views1 answer
Country code validation in laravel
PHP Laravel
0 vote145 views1 answer
Divi layout injector shortcode module in function php file
PHP
2 votes149 views1 answer
Php memory_limit cli
PHP