变为 string 用逗号隔开

list1 = ['1', '2', '3']
','.join(map(str, list)) 

变 string 加引号且加逗号

demo

# convert list user id to string
str_user_id = ','.join(map("'{0}'".format, list_user_id))

pandas read sql escape quotes

# get data from database
connection = fn_get_inside_user_connection()
sql = "SELECT UserID, JudgeStatus, COUNT(*) AS Num FROM IM_Practice " \
      "INNER JOIN IS_Student ON IS_Student.Id = IM_Practice.StudentID " \
      "INNER JOIN IS_School ON IS_School.Id = IS_Student.SchoolID " \
      "WHERE MachineResult > 0 " \
      "AND UserID IN ( %s ) " \
      "GROUP BY UserID, JudgeStatus" % str_user_id
df_teacher_mark_info = pd.read_sql(sql, connection)