laravel 查询文章表每个类别下的最新n条数据？

Question

如题，不知有没有好的解决方案？

Answer 1

需要一个类别, 一个类别的查. 没什么好办法一次查询.

Answer 2

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;