Mysql join in codeigniter

                        $this->db->select('*');
$this->db->from("table1");
$this->db->join("table2","users.id=table1.user_id","left");