如何使用swift在领域中执行join查询？

import MySQL

// 创建数据库连接
let mysql = MySQL()
let connected = mysql.connect(host: "localhost", user: "username", password: "password", db: "database")

if connected {
    // 执行JOIN查询
    let query = "SELECT * FROM table1 JOIN table2 ON table1.id = table2.id"
    let result = mysql.query(query: query)
    
    // 处理查询结果
    if let resultSet = result {
        let fields = resultSet.fieldNames()
        
        while resultSet.next() {
            var row = [String: Any]()
            
            for field in fields {
                let value = resultSet.getFieldString(field)
                row[field] = value
            }
            
            // 处理每一行数据
            print(row)
        }
    }
    
    // 关闭数据库连接
    mysql.close()
} else {
    print("Failed to connect to the database.")
}