Group::usersHasCommonGroup

static function usersHasCommonGroup(int $userIdA, int $userIdB): bool
{
	if (!Loader::includeModule('socialnetwork'))
	{
		return false;
	}

	global $DB;

	$sql = '
		SELECT count(*) as cnt
		FROM b_sonet_user2group ug
		INNER JOIN b_sonet_user2group ug2
			ON ug.GROUP_ID = ug2.GROUP_ID 
			AND ug2.USER_ID = '. $userIdB .'
			AND ug2.ROLE IN ("'. implode('","', BitrixSocialnetworkUserToGroupTable::getRolesMember()) .'")
		WHERE 
			ug.USER_ID = '. $userIdA .'
			AND ug.ROLE IN ("'. implode('","', BitrixSocialnetworkUserToGroupTable::getRolesMember()) .'")
	';

	$res = $DB->query($sql);
	$row = $res->fetch();
	if ($row && (int) $row['cnt'] > 0)
	{
		return true;
	}

	return false;
}