SELECT * FROM dic_GongZi as Father join dic_GongZi as Children on Father.Id=Children.ParentId FOR XML AUTO