$res = $this->db->select(array('bunch of fields'))->join('users',"users.email = '".$email."'", 'left')->more_joins_and_stff

SELECT <columns> FROM (`table_name`) LEFT JOIN `users` ON `users`.`email` = "`nightskywriter@gmail`.`com"` <more joins> WHERE <table_name_condition>