在Eloquent中嵌套了一对多的关系

Question

Let's say I have three models with this relationsship

USER hasMany (app/organisation)

ORGANISATION hasMany (app/order)

ORDER

For one level I could just go user->organisations()->get()

And get all the organisations tied to the user. But every organisation also have 0..many ORDER entities. So I want to do this:

user->organisations()->orders()->get()

To get a list of all the orders from all the organisations from a certain user. Is that possible this way?

Answer 1

What you can simply do is implement hasManyThrough() relationship on User model.

public function orders()
{
    return $this->hasManyThrough(Order::class, organisation::class);
}

then you can query like,

$user->orders()->get();