HasManyThrough with polymorphic and many-to-many relations

Question

In my Laravel application I have the following classes:

class Product extends Model
{
    public function extended()
    {
        return $this->morphTo();
    }

    public function users {
        return $this->belongsToMany('App\User', 'products_users', 'product_id');
    }
}

class Foo extends Model 
{
    public function product()
    {
        return $this->morphOne('App\Product', 'extended');
    }
    public function bars()
    {
        return $this->hasMany('App\Bar');
    }
}

class Bar extends Model 
{
    public function product()
    {
        return $this->morphOne('App\Product', 'extended');
    }

    public function foo()
    {
        return $this->belongsTo('App\Foo');
    }
}

class User extends Model
{
    public function products()
    {
        return $this->belongsToMany('App\Product', 'products_users', 'user_id');
    }
}

I can easily get users of a bar object using Bar::find(1)->product->users and I can also get the bars of a user with User::find(1)->products.

How can I get the users of all bars belonging to a specific foo? That is, Foo::find(1)->users should return all users that have the bars belonging to Foo with id 1. It's basically hasManyThrough with polymorphic and many-to-many relations.

score 3 · Answer 1 · edited May 01 '16 at 22:44

3

Try something like this:

public function users()
    {
        $Foo = static::with(['bars', 'bars.products', 'bars.product.users'])->get();
        return collect(array_flatten(array_pluck($Foo, 'bars.*.product.users')));
    }

This should work for you (code has been tested, but not against the exact same structure as your setup). The first line will return all the users deeply nested through the relationships. The second line will pull out the users, flatten them into an array, then transform the array into a collection.

edited May 01 '16 at 22:44

Peter O.

32,158
14
82
96

answered Apr 25 '16 at 19:03

Patrick Stephan

1,809
16
23

This seems to include users that aren't related to the given Foo – Oskar Persson May 02 '16 at 16:32
use a `find` statement instead of a `get` statement then: `$Foo = static::with(['bars', 'bars.products', 'bars.product.users'])->find($this->id);` (assuming your primary key is `id`) – Patrick Stephan May 03 '16 at 14:43

score 1 · Answer 2 · answered Sep 24 '18 at 23:58

I created a HasManyThrough relationship for cases like this: Repository on GitHub

After the installation, you can use it like this:

class Foo extends Model {
    use \Staudenmeir\EloquentHasManyDeep\HasRelationships;

    public function users() {
        return $this->hasManyDeep(
            User::class,
            [Bar::class, Product::class, 'products_users'],
            [null, ['extended_type', 'extended_id']]
        );
    }
}

HasManyThrough with polymorphic and many-to-many relations

2 Answers2