如何编写嵌套select sql查询与主义查询构建器？

import mysql.connector

# 建立数据库连接
cnx = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

# 创建查询构建器
query_builder = cnx.cursor(buffered=True)

# 构建主查询
query = """
SELECT column1, column2
FROM table1
WHERE column3 = 'value'
"""

# 执行主查询
query_builder.execute(query)

# 获取主查询结果
results = query_builder.fetchall()

# 遍历主查询结果
for row in results:
    # 获取主查询结果的字段值
    column1_value = row[0]
    column2_value = row[1]

    # 构建嵌套SELECT查询
    nested_query = """
    SELECT column4
    FROM table2
    WHERE column5 = '{}'
    """.format(column1_value)

    # 执行嵌套SELECT查询
    query_builder.execute(nested_query)

    # 获取嵌套查询结果
    nested_results = query_builder.fetchall()

    # 输出嵌套查询结果
    for nested_row in nested_results:
        column4_value = nested_row[0]
        print("Nested Result: ", column4_value)

# 关闭数据库连接
cnx.close()