Communication via Laravel table?

Question

Laravel

Tell me, there are 3 models:
Purchase, Product, Category
Purchase and Category are connected through Product (Product has purchase_id and category_id properties).
How do I get all Purchases of a certain category? More precisely, how to describe the relationship? hasManyThrough is not suitable, because where the models must be linked in a chain.
Thank you.

Answer 1

For example, we have a structure like this

product table:
id, name, purchase_id, category_id category
table:
id, name
purchase table:
id, total

In the Product model:

public function purchase(){
    $this->hasMany('Purchase');
}

In this case, you can get all purchase categories using whereHas.
Sample code (not tested):

$purchases = Product::with('purchase')->whereHas('category', function($query){
   $query->where('id', 1);
})->get()->lists('purchase');

But the structure is initially wrong. You need to rethink it.