title: Join query with multiple ON condition not working in codeigniter?
body: <p>I need a query like this</p>
  
  <pre><code>SELECT * FROM (`users`) 
       LEFT JOIN `users_phone_numbers`     
                ON `users`.`id`= `users_phone_numbers`.`user_id` 
       LEFT JOIN `phone_number`
               ON (`phone_number`.`id`= `users_phone_numbers`.`phone_num_id` AND users_phone_numbers.is_active = 1)
  WHERE `users`.`id` = 56
  </code></pre>
  
  <p>i have code like this in codeigniter</p>
  
  <pre><code>$this-&gt;db-&gt;select('*');
  $this-&gt;db-&gt;from('users');
  $this-&gt;db-&gt;join('users_phone_numbers',
                                'users.id= users_phone_numbers.user_id',
                                'left');
              $this-&gt;db-&gt;join('phone_number',
                                '(phone_number.id= users_phone_numbers.phone_num_id AND users_phone_numbers.is_active = 1)',
                                'left'); 
  $this-&gt;db-&gt;where('users.id = '. $id); 
   $result =  $q-&gt;result_array(); 
  </code></pre>
  
  <p>But i got this error   </p>
  
  <p><img src="https://i.stack.imgur.com/vkT9j.png" alt="But i got this error"></p>