메뉴 계층 쿼리 참고¶

WITH RECURSIVE t3 (menu_id, menu_nm, depth, parent_id, sort_odr) AS
(
    SELECT t1.menu_id, t1.menu_nm, t1.depth, t1.parent_id, t1.sort_odr
    FROM user_menu t1
    WHERE t1.parent_id IS NULL

    UNION ALL

    SELECT t2.menu_id, t2.menu_nm, t2.depth, t2.parent_id, t2.sort_odr
    FROM user_menu t2
    INNER JOIN t3 ON t2.parent_id = t3.menu_id
)
SELECT * FROM t3
ORDER BY t3.sort_odr;