union 查询树结构

在实际工作中，很多时候我们会将树形结构数据保存在一张表里

简化结构如下图：

现在我们来造一些数据，使其符合树形结构

declare @num int = 3, @child int = 3
declare @level1_index int = 0, @level2_index int = 0, @level3_index int = 0

while @level1_index < @num
begin
	insert into Tree(Name) values('a_' + CONVERT(varchar, @level1_index))
	declare @level1 int = @@identity	
	declare @level2_name varchar(30) = 'b_' + convert(varchar, @level1) + '_';
	set @level2_index = 0
	while @level2_index < @child
	begin		
		insert into Tree(ParentId, Name) values(@level1, @level2_name + CONVERT(varchar, @level2_index))
		declare @level2 int = @@IDENTITY
		declare @level3_name varchar(30) = 'c_' + convert(varchar, @level2) + '_&#