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

Question

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

Answer 1

selecta.*
from
titlea,
(selectgroup_concat(tidorderbytiddesc)gtid
fromtitlegroupbytype)b
wherefind_in_set(a.tid,b.gtid)between1andn
orderbytype,tiddesc;