php - Highlighting if entity is 'Member of' result set

Question

I have two entities, Client and Group:

class Client {
    /**
     * @ORMId()
     * @ORMGeneratedValue()
     * @ORMColumn(type="integer")
     */
    private $id;

    /**
     * @ORMManyToOne(targetEntity=Group::class, inversedBy="clients")
     * @ORMJoinColumn(nullable=false)
     */
    private $group;
}

class Group {
    /**
     * @ORMId()
     * @ORMGeneratedValue()
     * @ORMColumn(type="integer")
     */
    private $id;

    /**
     * @ORMOneToMany(targetEntity=Client::class, mappedBy="group")
     */
    private $clients;
}

What would be a DQL query I could run where I would get a full list of groups, with a flag to say whether a client with id = 1 is in the group?

If I was to do this in bog-standard SQL, I would do something like the following:

select *, (CASE WHEN c.client_id = 10 THEN 1 ELSE 0 END) as in_group
 from group
 left join client c on c.group_id = group.id

question from:https://stackoverflow.com/questions/66065704/highlighting-if-entity-is-member-of-result-set

Answer 1

Waitting for answers