Symfony User findByRole

find_by_role.php

<?php

public function findByRole(Role $role): mixed
{
    $rsm = $this->createResultSetMappingBuilder('u');

    $query = <<<SQL
        SELECT %s
        FROM user u
        WHERE u.roles::jsonb ?? :role
    SQL;

    $rawQuery = sprintf($query, $rsm->generateSelectClause());

    $query = $this->getEntityManager()->createNativeQuery($rawQuery, $rsm);
    $query->setParameter('role', $role->getValue());

    return $query->getResult();
}