如何使用 SQL 查询获取文章及其前 5 条评论？

select 
    tmp1.id, tmp1.content, tmp.comment
from
    (select
    a.pid, a.comment
     from
         `comment` a
     where
         5 > (select count(id) from `comment` b where b.pid = a.pid and a.id > b.id)
     order by
         a.id desc) tmp
     join article tmp1 on tmp.pid = tmp1.id

[
    {
        "id": 1,
        "content": "文章内容 1",
        "commentList": [
            {
                "commentid": 1,
                "comment": "评论 1"
            },
            {
                "commentid": 2,
                "comment": "评论 2"
            },
            {
                "commentid": 3,
                "comment": "评论 3"
            },
            {
                "commentid": 4,
                "comment": "评论 4"
            },
            {
                "commentid": 5,
                "comment": "评论 5"
            }
        ]
    },
    // ...其他文章的数据
]