Mybatis同表中的数据，xml映射文件里怎么写

Question

这是语句！

    select c2.id as first_id,
    c2.name as first_name,
    c2.create_time as first_create_time,
    c1.id as second_id,
    c1.name as second_name,
    c1.create_time as second_create_time
    from category c1 right join category c2 on c1.parent_id=c2.id where
    c2.parent_id is null;

这个是我自己写的映射文件！

    <resultMap type="Category" id="p1">
    <id property="id" column="first_id" />
    <result property="name" column="second_name"></result>
    <result property="createTime" column="first_create_time" />
    <collection property="category" javaType="java.util.List"
        ofType="Category">
        <id property="id" column="second_id" />
        <result property="name" column="second_name" />
        <result property="createTime" column="second_create_time" />
    </collection>
</resultMap>

这个是实体类类名就叫Category

private Integer id;
private String name;
private Date createTime;
private List<Category> category;

Answer 1

自己已经搞好了，怎么没有人回答！