118.codeigniter left join

$this->db->select('u.*,o.*');

        $this->db->from('tb_end_users as u');

        $this->db->join('tb_organizations as o', 'o.org_id = u.org_id','left');

        $this->db->where('u.euser_pk_id', $dpno);       

        $query=$this->db->get()->result();

        //print_r($this->db->last_query());  //to print query

        return $query;