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
代码如上，如何在mysql中转换