how to retrieve eloquent model, where a field in a related model equals "xx"?

Question

I have a two models "user" and "user_groups"

there is a relation between the two models like so:

public function usergroup()
{
    return $this->hasOne('App\user_group','id','group_id');
}

I can get all users of the group "drivers" using this method.

 $driversx = User::where('group_id',3)->get();

but I wanna get these users using the "group_name" field in the "user_groups" model.

how can I achieve that?

Add a belongs to relation in your user_groups model – Sapnesh Naik May 12 '17 at 12:21 — Sapnesh Naik, May 12 '17 at 12:21
can you please place a clear example. thank you... – medo ampir May 12 '17 at 12:43 — medo ampir, May 12 '17 at 12:43

score 1 · Accepted Answer · answered May 12 '17 at 12:51

1

User::whereHas('usergroup', function ($q) {
    $q->where('group_name', 'drivers');
})->get();

answered May 12 '17 at 12:51

Alexey Mezenin

score 0 · Answer 2 · edited May 23 '17 at 12:26

0

Generally we used like this way

  public function Menus(){

     return $this->hasOne('App\Models\MainMenu', 'id', 'menu_id');
}

Controller:

$menu_listing=MenuListing::with('Menus')->get();

But if you want to use with group_name go for belongs to

edited May 23 '17 at 12:26

Community

answered May 12 '17 at 12:29

Nil

I wish to use group_name , could you please make a clear example for it? – medo ampir May 12 '17 at 12:39

score 0 · Answer 3 · answered May 12 '17 at 12:55

0

For your belongsTo relationship :

public function users()
{
    return $this->hasMany('App\User','id','group_id');
}

and then :

$users = UserGroup::where('group_name', 'drivers')->first()->users

the name of your model may be not UserGroup :)

answered May 12 '17 at 12:55

Mathieu Ferre

3 Answers3