left join with where clause in codeigniter code example

Example 1: left join codeigniter

$this->db->join('user_email', 'user_email.user_id = emails.id', 'left');

Example 2: left join in codeigniter query builder

$this->db->select('p.id, p.photo, p.desc, info.desc');
$this->db->from('products as p');
$this->db->join('lang_info as info', 'info.id=p.id and info.lang='.$this->lang, 'left');
$this->db->where('p.id', $this->product_id);
$this->db->where_in('info.name', ['good', 'bad']);