python之循环python的多个变量

我正在尝试创建一个 for 循环以将用户定义的多个关联变量写入数据库，有没有办法做这样的事情？

import sqlite3 as lite 
import sys 
 
names = ( "John", "Sal", "Bill" ) 
ids = ( 123, 321, 231 ) 
 
con = lite.connect('test.db') 
cur = con.cursor() 
 
**for x in names and y in id:** 
 
  cur.execute("INSERT INTO People(Name, ID) VALUES('%s', %d)" % x y)