如何在获得最后插入的行id后插入多行

import mysql.connector

# 连接数据库
cnx = mysql.connector.connect(user='username', password='password', host='host', database='database')
cursor = cnx.cursor()

# 执行插入操作并获取最后插入的行id
query = "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')"
cursor.execute(query)
last_insert_id = cursor.lastrowid

# 构建多行插入的SQL语句
values = []
values.append(("value1", "value2"))
values.append(("value3", "value4"))
values.append(("value5", "value6"))
query = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"

# 执行多行插入操作
cursor.executemany(query, values)

# 提交事务
cnx.commit()

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