D.CAMP 리뉴얼

h1. 메뉴 계층 쿼리 참고

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;