Request to Eloquent. How to select 4 latest entries from each category?

Question

Laravel

There is, for example, a table posts, it has records with fields id, title, category_id, created_at, (each record can belong to one category category_id)
I can’t figure out how to write a query to pull the postslast four records from each category from the table ... as I understand it like that need to group them

Answer 1

If I understand you correctly, you can do this:

$categories = Category::with(['posts' => function($query) {
    $query->orderBy('created_at', 'desc')->take(4);
}])->get();