laravel 查詢文章表每個(gè)類別下的最新n條數(shù)據(jù)？

需要一個(gè)類別, 一個(gè)類別的查. 沒什么好辦法一次查詢.

Category::with(["posts" => function($q){
    $q->orderBy("id","desc")->take(10);
}])->get();

前提是你得在Category里面有posts這個(gè)關(guān)聯(lián)hasMany,
至于內(nèi)部是什么查的，可以看看執(zhí)行的sql

select a.* 
from 
    title a,
    (select group_concat(tid order by tid desc) gtid 
     from title group by type) b
where find_in_set(a.tid,b.gtid) between 1 and n
order by type,tid desc;