如何在嵌套的SELECT查询中使用带有字段到列映射、以键为ID的BeanMapHandler？

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanMapHandler;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Map;

public class NestedSelectQueryExample {
    public static void main(String[] args) {
        // 连接数据库
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";
        try (Connection connection = DriverManager.getConnection(url, username, password)) {
            // 创建查询器
            QueryRunner queryRunner = new QueryRunner();

            // 嵌套SELECT查询
            String sql = "SELECT t1.id, t1.name, t2.address FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id";

            // 字段到列映射
            FieldColumnMapping[] fieldColumnMappings = {
                    new FieldColumnMapping("id", "id"),
                    new FieldColumnMapping("name", "name"),
                    new FieldColumnMapping("address", "address")
            };

            // 以键为ID的BeanMapHandler
            BeanMapHandler<String, MyBean> beanMapHandler = new BeanMapHandler<>(String.class, MyBean.class, fieldColumnMappings);

            // 执行查询并获取结果
            Map<String, MyBean> resultMap = queryRunner.query(connection, sql, beanMapHandler);

            // 处理结果
            for (Map.Entry<String, MyBean> entry : resultMap.entrySet()) {
                String id = entry.getKey();
                MyBean bean = entry.getValue();
                System.out.println("ID: " + id);
                System.out.println("Name: " + bean.getName());
                System.out.println("Address: " + bean.getAddress());
                System.out.println("------------------------");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

// 定义Java对象
class MyBean {
    private String name;
    private String address;

    // 省略构造函数、Getter和Setter
}