/PHP/Laravel/Laravel get all users except role spatie

Laravel get all users except role spatie

You can make 2 querys to get both groups of users that you want. I mean:

1) Users who dont have any role.

User::whereDoesntHave('roles')->get();

2) Users have any role, but not admin (from Adam Kozlowski answer)

$this->users()->whereHas('roles', function ($query) {
    $query->where('name','!=', 'admin');
});

Similar codes

0 vote349 views1 answer
Laravel query builder select first
PHP Laravel
0 vote387 views1 answer
Laravel withValidator
PHP Laravel
0 vote348 views1 answer
Laravel Secured Password
PHP Laravel
0 vote343 views1 answer
Laravel 8 - get values of url query strings in controller
PHP Laravel
0 vote379 views1 answer
Laravel run php server by ipv4
PHP Laravel
7 votes329 views2 answers
Laravel check sql query
PHP Laravel
0 vote341 views1 answer
Null check nested object laravel
PHP Laravel
0 vote329 views1 answer
Displaying laravel error in below input field
PHP Laravel
4 votes372 views1 answer
Uuid nom package for laravel 18.04
PHP Laravel
9 votes332 views2 answers
A facade root has not been set laravel
PHP Laravel