mybatis 递归查询所有子分类写法

Bean：
public class Category {
    private Integer categoryid; //分类id
    private String name2;
    private String remarks;
    private List<Category> categoryList; //其下子集
}

    
Dao:
List<Category> getAllCategory(Integer pid);

mapping:
	<select id="getAllCategory" resultMap="getAllChildren">
        select 
			* 
		from 
			your_table 
		where 
			status=0 
			AND parent_id=#{parentId}
    </select>

    <resultMap id="getAllChildren" type="Category">
        <id column="categoryid" property="categoryid"></id>
        <result column="name2" property="name2"></result>
        <collection property="categoryList" select="getAllCategory" column="categoryid"></collection>
    </resultMap>