import sqlite3

conn = sqlite3.connect('sample.db')
cur = conn.cursor()

# データの抽出
sql = """SELECT id, name
  FROM personal"""

data = cur.execute(sql)

while True:
  d = data.fetchone()
  if d == None: break
  print(d)

conn.close()