$categories = Category::with('news')->orderBy('id', 'ASC')->get();$categories = Category::with(['news' => function($query)
{
$query->limit(3);
}])->orderBy('id', 'ASC')->get();
Thehttps://laravel.com/docs/5.7/eloquent-relationship...limitandtakequery builder methods may not be used when constraining eager loads.
$articles = `SELECT category, id, title FROM (
SELECT c.name AS category, a.id, a.title, row_number() OVER (PARTITION BY categoryid ORDER BY a.sort DESC) AS row
FROM articles a INNER JOIN categories c ON (a.categoryid=c.dboid)
ORDER BY c.sort
) AS foo WHERE row <= 5;foreach ($categories as $category) {
category->load(['news' => function($q){
$q->take(5);
}]);
}
Простой
Простой
Простой