如何在多对多字段上进行搜索

import mysql.connector

# 连接数据库
cnx = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

# 获取要搜索的技能的ID或名称
skill_name = "Web Development"

# 在中间表"UserSkills"中查询具有该技能的用户的ID列表
cursor = cnx.cursor()
query = "SELECT user_id FROM UserSkills WHERE skill_id IN (SELECT id FROM Skills WHERE name = %s)"
cursor.execute(query, (skill_name,))
user_ids = [row[0] for row in cursor]

# 使用这些用户ID去查询"Users"表，获取相关用户的信息
query = "SELECT * FROM Users WHERE id IN ({})".format(','.join(['%s']*len(user_ids)))
cursor.execute(query, user_ids)
users = cursor.fetchall()

# 处理查询结果并返回相应的数据
for user in users:
    print("User ID:", user[0])
    print("Username:", user[1])
    print("Email:", user[2])
    print("...")  # 其他用户信息

# 关闭连接
cursor.close()
cnx.close()