We have Branches, Departments, sections ... first table is organization has ( Branch id and name ) second table is Department has ( *Parent id , department id , department name, and Branch id ) third table is sections has ( section id , section name , department id ) I want to create tree which should show organization name , department name , section name.

• Parent id is department id start with null the important point here is Department can be child of another department if there is Parentid and sections is child of department joining department id