Retrieving users profile and displaying it.

[eluser]puffnstuff[/eluser]
Just started with Codeigniter and I am using Ion Auth for members administration.

I have a table called "users" with a field of "id" and another "profile" with a field called "id".

When the user is logged in I would like to display the users profile with the equivalent id.

I think I am close to figuring this out. This is what I have in my users model...

Code:

function user_profile() {

  $this->db->select('*');
        $this->db->from('users');
        $this->db->join('profile', 'users.id = profile.id','left');
        $query = $this->db->get();
        
         return $query->result();
        
        

  
  
  }

I am not sure if I am way off base and if I am close I am not sure how to go from here to echo out the profile.