如何使用将存储在powershell变量中的用户列表作为输入的SQL查询来检索数据？

$connectionString = "Data Source=服务器地址;Initial Catalog=数据库名称;User ID=用户名;Password=密码"
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
$connection.Open()

$users = @("user1", "user2", "user3")

$query = "SELECT * FROM 表名 WHERE 用户名 IN ("
foreach ($user in $users) {
    $query += "'$user',"
}
$query = $query.TrimEnd(',') + ")"

$command = New-Object System.Data.SqlClient.SqlCommand($query, $connection)
$reader = $command.ExecuteReader()

# 遍历结果集
while ($reader.Read()) {
    # 处理每一行的数据
    $column1 = $reader["列名1"]
    $column2 = $reader["列名2"]
    # ...
}

$connection.Close()