how to get the hierarchical dat using recursive in php with codeigniter

the below function has recursive function for organizational chart; family_user table:

function getrel($userid)
{

      $sql =  'SELECT DISTINCT *  FROM family_user WHERE userid in ( SELECT  DISTINCT rel_id FROM family_rel WHERE tree_id ='.$userid.')';

       $query = $this->db->query($sql);                                        
       if ($query->num_rows() > 0)
       {
            foreach($query->result_array() as $row)

            {
                $user[] = $row['userid'];
                if(@in_array($row['userid'],$user))
                {
                    echo "---------->";
                    echo $row['userid'];
                    echo "</br>";                            
                    $this->getrel($row['userid']);        
                    //echo "HAI";                                            
                }                                           
            }                 
           // return $user;                    开发者_Python百科                                     
       }
}

the above function has no limit.please resolved

The code you have posted is going to be in an infinite loop when ever the userid provide while calling the function matches in the database.

To break a recursive loop there should be a condition which exits the loop after a finite number of run.

To provide you a good solution please elaborate what you would like to achieve with your code.