原则查询：混淆addWhere，Where或Where

$q->andWhere($q->getRootAlias().\'.is_published = ?\', 1);
$q->andWhere($q->getRootAlias().\'.published_at >= ?\', time());
$q->leftJoin($q->getRootAlias().\'.EventLdapGroup l\');
$q->andWhereIn(\'l.ldap_group_id\', $permissions_id );
$q->orWhere(\'l.ldap_group_id IS NULL);

FROM 
    Event r LEFT JOIN r.EventLdapGroup l 
WHERE 
    r.is_published = ? AND 
    r.published_at >= ? AND 
    l.ldap_group_id IN (?, ?) OR 
    l.ldap_group_id IS NULL

ldap_group_id

is_published

published_at

FROM 
    Event r LEFT JOIN r.EventLdapGroup l 
WHERE 
    r.is_published = ? AND 
    r.published_at >= ? AND 
    (l.ldap_group_id IN (?, ?) OR l.ldap_group_id IS NULL)