symfony中，使用原声的sql语句

/**
* 数组形式的原生sql
*/
public function arrayA(array $did)
{
$statement = $this->getEntityManager()->getConnection()->executeQuery('
    SELECT did, count(1) as num
    FROM position_structure
    WHERE did in (?)
    AND status = 1
    GROUP BY did
    ', array($did), array(Connection::PARAM_INT_ARRAY));
    return $statement->fetchAll();
}
 
/**
* 单个值的原生sql
*/
public function fetchCompaniesByUserId($userId){
    $statement = $this->getEntityManager()->getConnection()->prepare('
    SELECT c.id,c.name,c.type FROM company_admin ca
    LEFT JOIN company c ON c.id = ca.company_id
    WHERE ca.user_id = :userId');
    $statement->bindValue('userId', $userId);
    $statement->execute();
    return $statement->fetchAll();
}