Laravel limit for with?

Question

Laravel

Category::with(['products' => function($query) {
    $query->take(3);
}])->where('type', 1)->get();

This is how I try to select 3 products for each category. But the code doesn't work.
How to specify a limit for with?

Answer 1

You cannot do this in Eloquent. In fact, you only get 3 categories. Therefore, if there are not many products, you can select categories, and then make a map through the collection and remove unnecessary products. Or you can do something like:

$categories = Category::where('type', 1)->get();
$categories->each(function($category) {
    $category->products()->take(3)->get();
});

This will cause additional requests for each category...

Answer 2

This package helped
https://github.com/staudenmeir/eloquent-eager-limit