CODEWITHSUNDEEP
laraveleloquent
Tom
Tom

Reputation: 12988

Laravel Eloquent - Return Users with specific role (many-to-many relationship)

I have an application where I want to find all the users (from a specified client) with a certain role (in this case Super Admin)

A client can have many users

public function users() {
    return $this->hasMany(User::class);
}

A user can belong to many roles

public function roles() {
    return $this->belongsToMany(Role::class);
}

I want to be able to return all the users from a client with a specific role.

So in the Client Model I want something like:

public function superAdmins() {
    return ... // NOT SURE WHAT TO PUT HERE
}

Upvotes: 1

Views: 1053

Answers (1)

SuperDJ
SuperDJ

Reputation: 7661

When defining relations you can add where() statements as well.

This means you can use whereHas:

public function superAdmins() {
    return $this->hasMany(User::class)
              ->whereHas('roles', function($query) {
                  return $query->where('name', 'super');
              });
}

Upvotes: 2

Related Questions