多个ID，IN只能匹配第一个条件的解决方法

<select id="xxxx" resultType="实体类路径">
        SELECT a.id, a.name, GROUP_CONCAT(c.name ,'') menuName, d.name subName
        FROM crea_user_role a
        LEFT JOIN cera_user_role_menu_relation b ON (a.id = b.role_id)
        LEFT JOIN crea_sys_menu c ON FIND_IN_SET (c.id, b.menu_id)
        LEFT JOIN crea_sys_sub_menu d ON FIND_IN_SET (d.id, b.sub_meun_id)
        <include refid="userRoleList"/>
    </select>

SELECT a.menu_id menuId, a.sub_meun_id subMeunId, a.role_id releId,   (SELECT GROUP_CONCAT(b.name ,'') FROM crea_sys_menu b WHERE FIND_IN_SET (b.id, a.menu_id) ) menuName, GROUP_CONCAT(d.name ,'') subName  FROM cera_user_role_menu_relation a
       LEFT JOIN crea_sys_sub_menu d ON FIND_IN_SET (d.id, a.sub_meun_id) WHERE a.role_id = #{roleId}

-- MAX 最大  MIN最小  AVG平均数 COUNT返回记录条总数  SUM返回总和  GROUP BY 分组    ORDER BY a.create_time DESC ;  时间排序