通过文章id递归查询所有评论（xml）

<!--    通过文章id递归查询所有评论 -->
<select id="findByArticleId" resultMap="commentResultMap">SELECT * FROM mxg_comment WHERE parent_id = -1AND article_id = #{articleId}ORDER BY create_date DESC
</select><!--    将每条一级评论的id作为parentId来查询子评论-->
<select id="findByParentId" resultMap="commentResultMap">SELECT * FROM mxg_comment WHERE parent_id = #{id}
</select><resultMap id="commentResultMap" type="Comment" ><id column="id" property="id"/><result column="parent_id" property="parentId"/><result column="user_id" property="userId"/><result column="nick_name" property="nickName"/><result column="user_image" property="userImage"/><result column="article_id" property="articleId"/><result column="content" property="content"/><result column="create_date" property="createDate"/><collection property="children" javaType="list" ofType="Comment"column="id" select="findByParentId"/>
</resultMap>