求一存储过程, 返回树状结构的xml字符串
请各位大虾写个存储过程,返回一个xml格式字符串, 谢谢了...
有两张表,分别是如下2张
user
--id
--name
--dpmtid --部门id
department
--id
--name
--upid 上级部门id, 根目录为0
-------------返回的xml格式字符串---------------------------
<?xml version="1.0" encoding="UTF-8" ?>
<department>
<member id="10000048">liuyl4</member>
<member id="10000048">liuyl4</member>
<depart name="一级" id="57008604">
<member id="10000048">liuyl4</member>
<depart name="二级" id="48913940">
<member id="10000044">820127</member>
<member id="10000049">liuyanling222</member>
<member id="10000045">liu</member>
<depart name="三级" id="48913940">
<member id="10000044">820127</member>
<member id="10000049">liuyanling222</member>
<depart name="四级" id="48913940">
<member id="10000044">820127</member>
<member id="10000045">liu</member>
</depart>
</depart>
<depart name="三级" id="48913940">
<member id="10000044">820127</member>
<member id="10000049">liuyanling222</member>
<member id="10000045">liu</member>
<depart name="四级" id="48913940">
<member id="10000044">820127</member>
<member id="10000045">liu</member>
</depart>
</depart>
</depart>
<depart name="二级" id="48913940">
<member id="10000044">820127</member>
<member id="10000049">liuyanling222</member>
<member id="10000045">liu</member>
<depart name="三级" id="48913940">
<member id="10000044">820127</member>
<member id="10000049">liuyanling222</member>
<member id="10000045">liu</member>
</depart>
</depart>
</depart>
<depart name="一级" id="57008604">
<member id="10000048">liuyl4</member>
</depart>
</department>