python+mysql数据库连接与查询

假设有一个这样的数据库：

 我需要用现在有的user_face_code去和数据库里面的做比对，输出符合要求的user_id和user_name:

import pandas as pd
import sqlalchemy

engine = sqlalchemy.create_engine("mysql+pymysql://root:root@192.168.4.13:3306/aitools")

sqlfunc = """select user_id,user_name,user_face_code from user"""
df = pd.read_sql(sqlfunc,engine)
# print(df)
print(df[(df['user_face_code']=='5')])

import pandas as pd
import sqlalchemy

engine = sqlalchemy.create_engine("mysql+pymysql://root:root@192.168.4.13:3306/aitools")

sqlfunc = """select user_id,user_name,user_face_code from user"""
df = pd.read_sql(sqlfunc,engine)
# print(df)
# 假设2是现有的user_face_code
anewdf = df[(df['user_face_code']=='2')]
print(anewdf)
# print(anewdf.columns)
# a = (anewdf['user_id']) # 需要返回的东西
# print(a)

id,name = anewdf['user_id'],anewdf['user_name'] # 拿到对应的id和name
print('*'*50)
print(id.values,name.values)