I have scenario where one user can refer two codes to other one will become right and other left.Now this right can have two child left and right and so on same for left child user.... So this is binary tree like strucutre

so i am selecting a user from database which current login user now binary tree will be displayed.I have coloumn in database which is postion which will have value left or right.So for current login user there will be rows returned one is left and other right now i want to continue to process this thing till end of tree and save all these value in suitable array structure which must determined this is top most user it have left and right and both lchild and rchild and two child each respectively.

By current approcach]

/**function chain($user){
    $query="SELECT username, position FROM users WHERE sponsor_id='$user'";
    $check=mysqli_query($connect,$query) or die(mysqli_error($connect));
    while ($row=mysqli_fetch_assoc($check)){

     $data['lchild'] =$child_name;
     $data['lpos'] =$child_pos;
    }else if($child_pos=="right"){  
    $data['rchild'] =$child_name;
    $data['rpos'] =$child_pos;
    }else if($child_pos==''){
     echo "No User found"; 




plz help me in this banging my head from two days :)

can anyone help me with this?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.