在python/sqlite3中使用for循环设置与另一个表相关的外键

import sqlite3

conn = sqlite3.connect('database.db')

cursor = conn.cursor()

cursor.execute('''CREATE TABLE main_table (
                    id INTEGER PRIMARY KEY,
                    name TEXT
                )''')

cursor.execute('''CREATE TABLE related_table (
                    id INTEGER PRIMARY KEY,
                    main_id INTEGER,
                    FOREIGN KEY(main_id) REFERENCES main_table(id)
                )''')

main_data = [('John'), ('Alice'), ('Bob')]
for data in main_data:
    cursor.execute("INSERT INTO main_table (name) VALUES (?)", (data,))

related_data = [(1,), (2,), (3,)]
for data in related_data:
    cursor.execute("INSERT INTO related_table (main_id) VALUES (?)", (data,))

conn.commit()
conn.close()