mysql
WITH n(parentId) AS
(SELECT menuId
FROM TSYS_MENU
WHERE menuid in
#{item}
UNION ALL
SELECT parentId
FROM TSYS_MENU
WHERE menuid in
#{item}
UNION ALL
SELECT nplus.parentId
FROM TSYS_MENU as nplus, n
WHERE n.parentId = nplus.menuid)
SELECT distinct parentId FROM n where parentId is not null
1 |
|