WITH tree_query AS (
SELECT
menu_no,
menu_parent,
menu_name,
menu_depth,
menu_url,
convert(varchar(255), menu_no) sort,
convert(varchar(255), menu_name) depth_fullname
FROM seprob_menu
WHERE menu_no = '1000001'
UNION ALL
SELECT
B.menu_no,
B.menu_parent,
B.menu_name,
B.menu_depth,
B.menu_url,
convert(varchar(255), convert(nvarchar,C.sort) + ' > ' + convert(varchar(255), B.menu_no)) sort,