如何使用C#在MongoDB中连接两个表，其中一个表包含另一个表ID列表

var connectionString = "mongodb://localhost:27017";
var client = new MongoClient(connectionString);

var database = client.GetDatabase("mydatabase");
var collection1 = database.GetCollection<BsonDocument>("collection1");
var collection2 = database.GetCollection<BsonDocument>("collection2");

var query = from doc1 in collection1.AsQueryable()
            join doc2 in collection2.AsQueryable() on doc1["id"] equals doc2["id"]
            select new
            {
                Field1 = doc1["field1"],
                Field2 = doc2["field2"]
            };

foreach (var result in query)
{
    Console.WriteLine($"Field1: {result.Field1}, Field2: {result.Field2}");
}