如何编写左连接for make循环

SELECT users.id, users.name, orders.order_id, orders.product
FROM users
LEFT JOIN orders ON users.id = orders.user_id;

import sqlite3

# 连接到数据库
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 创建表
cursor.execute('''
CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL
)
''')

cursor.execute('''
CREATE TABLE IF NOT EXISTS orders (
    order_id INTEGER PRIMARY KEY,
    user_id INTEGER,
    product TEXT NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users (id)
)
''')

# 插入示例数据
cursor.execute("INSERT INTO users (name) VALUES ('Alice')")
cursor.execute("INSERT INTO users (name) VALUES ('Bob')")
cursor.execute("INSERT INTO orders (user_id, product) VALUES (1, 'Book')")
cursor.execute("INSERT INTO orders (user_id, product) VALUES (1, 'Pen')")

# 执行左连接查询
cursor.execute('''
SELECT users.id, users.name, orders.order_id, orders.product
FROM users
LEFT JOIN orders ON users.id = orders.user_id
''')

# 获取并打印结果
results = cursor.fetchall()
for row in results:
    print(row)

# 关闭连接
conn.close()