$qb = $this->createQueryBuilder('c')
    ->select('c', 'c1.id parent_id', 'COUNT(c.id) subcount')
    ->where('c.deleted = 0')
    ->groupBy('c.parent');

if ($ids) {
    $qb->andWhere($qb->expr()->in('c.parent', $ids));
}