Is it possible with Active Record?

PHP Code:

 $sql = "SELECT id, fullname, phone FROM users WHERE country=(SELECT country_id FROM country WHERE name=?) AND  type=?"; 


Simple with query bindings (without AR or QB):

PHP Code:

$sql = "SELECT id, fullname, phone FROM users WHERE country=(SELECT country_id FROM country WHERE name=?) AND  type=?";
$this->db->query($sql, array($name, $type)); 


Query Bindings