springboot 多表查询

<resultMap type="com.example.demo.bean.Diary" id="DiaryMap">
        <id property="id" column="_id" />
        <result property="title" column="title" />
        <result property="content" column="content" />
        <result property="pubTime" column="pub_time" javaType="java.sql.Date" />
        <association property="user" column="user_id"
            javaType="com.example.demo.bean.User">
            <id property="id" column="uId" />
            <result property="name" column="name" />
            <result property="sex" column="sex" />
            <result property="sign" column="sign" />
            <result property="photo" column="photo" />
            <result property="age" column="age" />
        </association>
        <collection property="tags" ofType="com.example.demo.bean.Tags"
            column="_id" select="com.example.demo.mapper.TagMapper.getTagsByDiaryId">
        </collection>
    </resultMap>

    <select id="getDiaryById" parameterType="int" resultMap="DiaryMap">
        select
        d._id,d.title,d.content,d.pub_time,d.user_id,u._id as
        uId,u.name,u.sex,u.sign,u.photo,u.age
        from diary d left join users u on
        d.user_id=u._id where d._id=#{id}
    </select>

    <select id="getAllDiary" resultMap="DiaryMap">
        select
        d._id,d.title,d.content,d.pub_time,d.user_id,u._id as
        uId,u.name,u.sex,u.sign,u.photo,u.age
        from diary d left join users u on
        d.user_id=u._id
    </select>

    <resultMap type="com.example.demo.bean.Diary" id="DiaryMap2">
        <id property="id" column="_id" />
        <result property="title" column="title" />
        <result property="content" column="content" />
        <result property="pubTime" column="pub_time" javaType="java.sql.Date" />
        <result property="userId" column="user_id" />
        <association property="user" column="user_id"
            javaType="com.example.demo.bean.User" select="com.example.demo.mapper.UserMapper.getUserById">
        </association>
        <collection property="tags" ofType="com.example.demo.bean.Tags"
            column="_id" select="com.example.demo.mapper.TagMapper.getTagsByDiaryId">
        </collection>
    </resultMap>

    <select id="getDiaryById2" parameterType="int" resultMap="DiaryMap2">
        select
        * from diary where _id=#{id}
    </select>