When create a query, I want to use `join` twice like the following:

```
$this->db->select('*');
$this->db->from('members');
$this->db->join('members_group', 'members_group.mgid = members.mgid');
$this->db->join('members_profiles','members_profiles.mid = members.mid');
$this->db->where('members.mid=' . $id);
$this->db->get()

```

The problem in the `join` statement number 2, If there is no data within the `members_profiles` table, the query return empty array. but if I remove the `join` statement number 2, the result will be correct data.

**How can I make the query return data whether** `members_profiles` **table contains of data that related to a member or not**?