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 vote324 views1 answer
Header return back php
PHP
0 vote315 views1 answer
Change php version in vagrant
PHP
62 votes352 views5 answers
Convert string to int php 7
PHP
0 vote282 views1 answer
Acf create post with fields
PHP
0 vote316 views1 answer
How to show login user name in php
PHP
15 votes349 views3 answers
Laravel setup auth
PHP Laravel
2 votes341 views1 answer
Create guid in php
PHP
2 votes318 views1 answer
Laravel delete model with all relations
PHP
12 votes342 views4 answers
Laravel auth setup
PHP
5 votes328 views5 answers
Laravel csrf token off
PHP Laravel