mybatis 查询集合字段

SysRole.java:

 @TableField(exist = false)
    private List<SysRole> roles;


UserMapper:
<collection property="roles" javaType="ArrayList"
                    column="{userId = user_id}"
                    select="com.zdl.system.mapper.Mapper.getListByUserId"/>



interface Mapper.java:

List<Role> getListByUserId(@Param("userId") Long userId);


SysRoleMapper:

    <select id="getListByUserId" resultMap="SysRoleResult">
        SELECT
            sr.*
        FROM
            sys_user_role sur
        LEFT JOIN sys_role sr ON  sr.role_id = sur.role_id
        WHERE
        sr.status = 0
        AND sur.user_id = #{userId}
    </select>