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

2 votes274 views1 answer
Global laravel request()
PHP
6 votes290 views2 answers
Get value from input field in php
PHP
0 vote355 views1 answer
Create symfony demo app
PHP Symfony
1 vote309 views1 answer
Laravel create project in current directory
PHP Laravel
14 votes271 views3 answers
Php code to convert to small letter
PHP
0 vote295 views1 answer
How to write orderby in join query with where clause in codeigniter
PHP
73 votes305 views6 answers
Iterate through array javascript
PHP
0 vote276 views1 answer
Search a file name and open that file phpstrom
PHP
9 votes286 views4 answers
Composer require laravel/ui for laravel 6
PHP Laravel
0 vote272 views1 answer
Make select element readonly
PHP