How to get many Many-to-Many relationships through one pivot table?

Question

Laravel

There is a table for linking product properties and their values.

public function features()
{
    return DB::table('feature_product_pivot')
        ->leftJoin('features', 'feature_product_pivot.feature_id',
                   '=', 'features.id')
        ->leftJoin('feature_values', 'feature_product_pivot.value_id',
                   '=', 'feature_values.id')
        ->leftJoin('feature_units', 'feature_product_pivot.unit_id',
                   '=', 'feature_units.id')
        ->where('product_id', $this->id)
        ->get();
}

Is it possible to implement a query using Eloquent and relationships?

At the moment, I am considering using an intermediate model **ProductFeature** for a given table that will be associated with a product.

What is the best way to implement this type of task?

Answer 1

No join needed. Open the documentation and read how to use links.