https://symfonycasts.com/screencast/doctrine-queries/select-new-object
class YourDTO
{
public function __construct(
private $login,
private $allYourFields,
...
) {}
}
$qb->select('NEW ' . YourDTO::class . '(c.login, c.char_name,c.id,c.sex,c.pvpkills,c.pkkills,c.online,c.online_time,c.last_access,MAX(cs.level) as lvl,sub.name,sub.clan_id)')