各位大神，看看我这个递归是哪里错了

Question

ofType="SysMenu" select="menuJsonByUserId">

<select id="menus" resultMap="SysMenuResult" parameterType="Role">
    SELECT
        m.MENU_ID,
        m.MENU_NAME,
        m.ICON,
        m.URL,
        m.PID
    FROM
        SYS_ROLE R
    LEFT JOIN SYS_ROLE_MENU S ON S.ROLE_ID = R.ROLE_ID
    LEFT JOIN SYS_MENU M ON S.MENU_ID = M .MENU_ID
    LEFT JOIN SYS_USER_TB U ON U .ROLE_ID = R.ROLE_ID
    WHERE m.pid = -1 order by MENU_ID
</select>

<select id="menuJsonByUserId" parameterType="Role" resultMap="SysMenuResult">
    SELECT
        m.MENU_ID,
        m.MENU_NAME,
        m.ICON,
        m.URL,
        m.PID
    FROM
        SYS_ROLE R
    LEFT JOIN SYS_ROLE_MENU S ON S.ROLE_ID = R.ROLE_ID
    LEFT JOIN SYS_MENU M ON S.MENU_ID = M .MENU_ID
    LEFT JOIN SYS_USER_TB U ON U .ROLE_ID = R.ROLE_ID
    WHERE U.ID = #{userId} 
</select>

大概就是 根据用户查询用户的角色 然后 查询对应角色的菜单 这个SQL 我写了三天了没写出来

Answer 1

http://tieba.baidu.com/p/4827554078