Выбрать из базы оператором IN + ПОДКЛЮЧЕНИЕ ЧЕРЕЗ PDO К mssql

$str_users = '';
$UIDS = [];
while ($user = $rsUser->Fetch())
{
    if(!empty($user['UF_CARD_NUMBER'])){
        $str_users .= "'".$user['UF_CARD_NUMBER']."', ";
        $UIDS[$user['UF_CARD_NUMBER']] = $user['ID'];
    }
}

$str_users = substr($str_users,0,-2);

    $host = $con['SERVER'].":".$con['port'];
    $dbname = $con['DATABASE'];
    $user = $con['UID'];
    $pass = $con['PWD'];
    try {
        $DBH = new PDO("dblib:host=$host;dbname=$dbname", $user, $pass);    }
    catch(PDOException $e) {
        echo $e->getMessage();
    }

    $stmt = $DBH->query("SELECT
                          EMP.SIFR AS SIFR,
                          EMP.CardCode AS CARDCODE,
                          EMP.NAME AS NAME
                          FROM EMPLOYEES AS EMP
                          WHERE CARDCODE IN (".$str_users.")");
    $rows = $stmt->fetchAll();