How to get two roles in Eloquent?

Hi guys what should be the proper query to display users with role of a member and admin?

If I have a query like this $data = User::role('admin')->get(); all admin will show but what if I want to display admin and member?

I tried $data = User::role('admin','member')->get(); i got error

Best Answer

Level 6

okat I got it.

$data = User::whereHas('roles', function($q){
    $q->where('name', 'member')
        ->orWhere('name','admin');
})->get();

Please or to participate in this conversation.