GeneralChat::getUsersForInstall

private function getUsersForInstall(): array
{
	if (Loader::includeModule('intranet'))
	{
		$sql = "
			SELECT DISTINCT U.ID
			FROM
				b_user U
				INNER JOIN b_user_field F ON F.ENTITY_ID = 'USER' AND F.FIELD_NAME = 'UF_DEPARTMENT'
				INNER JOIN b_utm_user UF ON
					UF.FIELD_ID = F.ID
					AND UF.VALUE_ID = U.ID
					AND UF.VALUE_INT > 0
			WHERE
				U.ACTIVE = 'Y'
				AND U.EXTERNAL_AUTH_ID IS NULL
				AND F.ENTITY_ID = 'USER'
				AND F.FIELD_NAME = 'UF_DEPARTMENT'
		";
	}
	else
	{
		$sql = "
			SELECT ID
			FROM b_user U
			WHERE 
			    U.ACTIVE = 'Y'
				AND U.EXTERNAL_AUTH_ID IS NULL
		";
	}

	$connection = BitrixMainApplication::getConnection();
	return $connection->query($sql)->fetchAll();
}