Pagination under load function (eager loading)

You need to understand how eager loading works...

$categories = Category::where('somthing', $something)->get();
return $categories->load(['articles']);

// Means Fetch all categories where something = $something
//Fetch all articles where category_id in (list of ids loaded above)

$categories = Category::where('somthing', $something)->get();

return $categories->load(['articles' => function($q) {
    $q->latest()->paginate()
}]);

// Means Fetch all categories where something = $something
//Fetch all articles where category_id in (list of ids loaded above) Limit x,y

Where do you see,fetch ... limit x,y per category being applied ???

Eager loading is not intended to limit the number of related items per parent item, as @d3xt3r mentionned above, only one query is executed to load the related item.

The query you want to achieve is extremely difficult with sql. http://stackoverflow.com/questions/2129693/using-limit-within-group-by-to-get-n-results-per-group

Thank you @d3xt3r, @pmall, so what's the solution to retrieve 15 articles for each category in one request ?

Either you load it an once and loop through each category, and implement your paginator on $category->article, or as @pmall suggested, implement it using sql.

Edit: To support what has been already said http://stackoverflow.com/questions/20913606/laravel-4-1-how-to-paginate-eloquent-eager-relationship