SELECT COUNT(*) AS cityCount
FROM `users_kindergardens` AS uk
INNER JOIN `users` AS u ON u.id = uk.user_id
WHERE uk.kindergarden_id = " . (int) $kindergardenID . "
AND u.TYPE = 'CITY'
AND u.STATUS = 'ACTIVE'