How to get N news of each category in laravel using eloquent builder?

Question

Laravel

There is an array of id categories [1,2,3]. You need to choose 5 news from each category. But this is clearly the wrong solution...

return Category::whereIn('id', [1,2,3])
                ->with(
                    ['articles' => function ($query) {
                            $query->latest('published_at');
                            $query->take(5);
                        }
                    ]
                )->get();

With this code, the selection of articles takes forever on the last category

Answer 1

https://github.com/staudenmeir/eloquent-eager-limit
Out of the box limit in with doesn't work