Sub Queries or better way to do this?

first you need to add join line to be like this
$this->db->join('d_pools_second','d_pools_second.key_id=pools.pl_id');
then return by count like this
return $query->num_rows();