如何在按变量搜索时从一个表中选择user_ID并插入到另一个表中？Python my SQL

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()

sql = "SELECT user_ID FROM table1 WHERE variable = %s"
val = ("your_variable_value",)  # 替换为您要搜索的变量值
mycursor.execute(sql, val)
result = mycursor.fetchall()

for row in result:
    sql = "INSERT INTO table2 (user_ID) VALUES (%s)"
    val = (row[0],)
    mycursor.execute(sql, val)
    mydb.commit()

mydb.close()