How to create self join relation in user profile as we do in SQL table self join ? I want to apply caml query in user profile so that it could give me following out put
<Employee>
<ChildCount>9</ChildCount>
<HasParent>1</HasParent>
<MGR_ID>1</MGR_ID>
<ORG_ID>47611</ORG_ID>
<PreferredName>ANZEVINO,SHERI</PreferredName>
<Title>SR MGR</Title>
<Department>SERVICE DELIVERY</Department>
<WorkEmail>sales@aasoftech.com</WorkEmail>
<WorkPhone>123-456-7890</WorkPhone>
<Secretary>False</Secretary>
<PictureUrl>/_layouts/15/AAOrgChart/HRData/images/Sheri.jpg</PictureUrl>
<CellPhone>987-654-3210</CellPhone>
</Employee>
any help would be appreciated.
