mysql每个分类取前5条数据

[lzding]

category表，id,title
article表，id,title,cid
要取出每个分类下article表的前5条数据，并且category表的title也要取出来
sql语句怎么写呢？

下面是模板，需要循环出来
<dl>
<dt>分类标题</dt>
<dd>文章标题111</dd>
<dd>文章标题222</dd>
<dd>文章标题333</dd>
<dd>文章标题444</dd>
<dd>文章标题555</dd>
<dl>

[青鬆下的坚躯]

方法1：配合php，遍历查询每个分类前5条，然后合并
方法2：使用union
方法3：

SELECT art.*,cate.`title` AS cate_title FROM article AS art
LEFT JOIN category AS cate ON cate.`id`=art.`cid`
WHERE FIND_IN_SET(
    art.id,
    (SELECT 
      GROUP_CONCAT(id) AS id 
    FROM
      (SELECT 
        SUBSTRING_INDEX(GROUP_CONCAT(id), ',', 3) AS id 
      FROM
        article 
      GROUP BY cid) AS t)
  ) 
ORDER BY art.cid 

输出：

[qq_14857077]

看不懂代码是一种怎样的忧伤