$this->db->select('u.name, u.file', false);

$this->db->from('users_domains as u');
$this->db->where("EXISTS('domain as d', 'd.id = u.domain_id')");
$query = $this->db->get();