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

10 votes95 views2 answers
Laravel success message
PHP
0 vote123 views1 answer
Database interaction in codeigniter
PHP CodeIgniter
0 vote135 views1 answer
Laravel belongstomany prevent duplicates attach
PHP Laravel
1 vote92 views1 answer
Qr code generator php
PHP
0 vote92 views1 answer
Localhost/series/my database/demo.php
PHP
1 vote114 views1 answer
Wp get image alt
PHP Wordpress
10 votes95 views2 answers
ForeignId in laravel
PHP
33 votes139 views6 answers
Laravel query builder
PHP Laravel
2 votes129 views1 answer
PHP Warning: require(/vendor/autoload.php): failed to open stream: No such file or directory in /var/www/api-fase/bootstrap/autoload.php on line 17
PHP
0 vote93 views1 answer
Call to a member function delete() on null laravel 8
PHP