Laravel get all products from parent category or subcategory using eloquent

Question

I would like to retrieve all products of chosen parent category.Product model have hasmany relation to product_category_mapping table.

If product have subcategory result like,

"MAinCatergory":[
    {
        id="",
        name:"Drinks",
        "ChildCategory":[
            {
                "id":1,
                "name":"Juce",
                "Products":[{
                   name:"apple juce",
                   price:10,
                    ....
               }]
            }
        ]
    }
]

}

If product under main category only return array like,

"MAinCatergory":[
    {
        id="",
        name:"Drinks",
                "Products":[{
                   name:"apple juce",
                   price:10,
                    ....
               }]
            }
    }
]

}

category table fields - id,name,parent_id

product table fields - id,name,price,..,

product-category-mapping table fields - id,category_id,product_id

category model

public function children()
{
  return $this->hasMany('App\Models\Category', 'parent_id');
}
public function parent()
{
  return $this->belongsTo('App\Models\Category', 'parent_id');
}
public function product_category()
{
  return $this->hasMany('App\Models\ProductCategoryMapping', 'category_id');
}

product model

public function product_category()
{
    return $this->hasMany('App\Models\ProductCategoryMapping','product_id');
}

product-category_mapping

public function product()
{
  return $this->belongsTo(Product::class,'product_id','id');
}
public function category()
{
  return $this->belongsTo(Category::class,'category_id','id');
}

Tipu Sultan Eiko Tipu Sultan Eiko · Accepted Answer · 2022-02-17T06:53:55

Something like this might suffice.

App\Models\Category::with('children', 'product_category.product')->get()

Suggestion, try implement pivot many to many relation instead this product_category_mapping, then model relation would change a bit.

For pivot relation, you need to modify the Category model

public function products()
{
  return $this->belongsToMany('App\Models\Product', 'product-category-mapping');
}

and in product Model

public function categories()
{
    return $this->belongsToMany('App\Models\Category','product-category-mapping');
}

This is not the complete integration, but to give you an idea, for full logic see https://laravel.com/docs/9.x/eloquent-relationships#many-to-many

Laravel get all products from parent category or subcategory using eloquent

2 Answers