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 vote222 views2 answers
Get all laravel validation failed messages
PHP
0 vote199 views1 answer
Ignore user id on email validation laravel
PHP
18 votes233 views6 answers
Set timezone in php
PHP
0 vote221 views1 answer
Artisan::call for all catch clear in laravel
PHP
23 votes234 views6 answers
Laravel 8 route
PHP Laravel
0 vote239 views1 answer
Laravel request img
PHP Laravel
0 vote319 views1 answer
Yii 2 create migration with fields
PHP Yii
0 vote248 views1 answer
Remove controller cache laravel
PHP Laravel
0 vote227 views1 answer
Require_once different on server
PHP
18 votes223 views4 answers
Protected table laravel
PHP Laravel