你可以使用zip()和executemany()喜欢这样:
zip()
executemany()
cursor.executemany("""INSERT INTO peopleList (Name, Surname, Car) VALUES (?,?,?)""", zip(name,surname,car))