The recursive query for SQL Server is the with CTE query

Table structure

Table Data

SQL as follows

With Lmenu as (select name,id,1 as lv,cast (name as nvarchar (max)) as name1, cast (Row_number () Up (order by GETDATE ()) as N varchar () as OrderID from   Table2 where table2.parentid=0 Union all  Select A.name, a.ID, (b.lv+1) as LV, Cast (REPLICATE ("  , b.lv*2) + a.name as nvarchar (max)) as name1,  cast ((b.orderid+ '. ') + CAST (Row_number () over (Order by GETDATE ()) as nvarchar (5))) as nvarchar (ten)) as   OrderID from   Table2 as a inner j Oin Lmenu as B on a.parentid=b.id) SELECT * from Lmenu  ORDER by   OrderID;

Query Result:

The recursive query for SQL Server is the with CTE query