1) Query MySQL using PHP
2) Fetch list of users that matches (i.e Find user with id=33 and retrieve all child and grand child under it) using the parent / sponsor id. It will be a multi level data i.e user id 33 may have two child 21 and 20 and each childs may have multiple childs and grand childs. It has to loop through 15 levels down.
3) Create a tree based on the result using users name and other parameters on google organizational chart or any other charting software.
28 freelancers are bidding on average $206 for this job
Hi, So all the records contains their own id, parent id right? That will lead to creation of a nested JSON array of object, which can be parsed into the chart library Thanks Ngan Le
Hi, I would like to generate the tree like structure from your database nested to 15 levels. Available for discussion and ready to start now. Regards, Manish