database modeling for a friend list

[eluser]bluepicaso[/eluser]
I found the Solution

here is the code for the model

Code:

function getUserFrnds($user_id, $num, $offset)
        {
            $this->db->select('*');
            $this->db->from('frnds');
            $this->db->where('frnds.usr_id', $user_id);
            $this->db->join('user', 'frnds.frnd_is = user.user_id', 'left');
            $this->db->join('country', 'user.cntry = country.cntry_id');
            $this->db->limit($num, $offset);
            $this->db->orderby('user.display_name');
            $query = $this->db->get()->result_array();
            foreach($query as $row)
            {
                if($row['user_id'] != $user_id)
                {
                    $data[] = $row;
                }
            }
            
            $this->db->select('*');
            $this->db->from('frnds');
            $this->db->where('frnds.frnd_is', $user_id);
            $this->db->join('user', 'frnds.frnd_is = user.user_id', 'left');
            $this->db->join('country', 'user.cntry = country.cntry_id');
            $this->db->limit($num, $offset);
            $this->db->orderby('user.display_name');
            $query2 = $this->db->get()->result_array();
            foreach($query2 as $row)
            {
                if($row['user_id'] != $user_id)
                {
                    $data[] = $row;
                }
            }
            

            
            //echo "<pre>";
            //print_r($data);
            //echo "</pre>";
            return $data;
            $this->db->close();
        }

generated results as expected.

Thank you JAY