树型数据格式为XML数据

比如
SQL code:

id pid name
1 null a
2 1 a1
3 null b
4 3 b1
5 4 b11
6 3 b2
....



等否得出如下格式的XML？

SQL code:

<item id='1' text='a'>
<item id='2' text='a1'></item>
</item>
<item id='3' text='b'>
<item id='4' text='b1'>
<item id='5' text='b11'></item>
</item>
<item id='6' text='b2'></item>
</item>
....




请各位大侠帮帮忙，谢谢

---

SQL code:
-- 导入去重, last() , position()

DECLARE @doc xml
SET @doc ='<?xml version="1.0" encoding="gb2312" ?>
<employees>
<employee>
<empid>e0001</empid>
<name>萧峰</name>
</employee>
<employee>
<empid>e0002</empid>
<name>段誉</name>
</employee>
<employee>
<empid>e0003</empid>
<name>王语嫣</name>
</employee>
<employee>
<empid>e000