mysql查询语句拼接

import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="mydatabase")
cursor = db.cursor()

query = "SELECT * FROM users WHERE username = %s AND password = %s"
values = ("admin", "password123")

cursor.execute(query, values)
results = cursor.fetchall()

SELECT * FROM orders WHERE customer_id IN (SELECT id FROM customers WHERE country = 'USA');

SELECT o.* FROM orders o JOIN customers c ON o.customer_id = c.id WHERE c.country = 'USA';

def get_user_orders(user_id):
    query = """
    SELECT * FROM orders 
    WHERE user_id = %s
    """
    values = (user_id,)
    return execute_query(query, values)

def execute_query(query, values):
    db = mysql.connector.connect(host="localhost", user="user", password="password", database="mydatabase")
    cursor = db.cursor()
    cursor.execute(query, values)
    results = cursor.fetchall()
    cursor.close()
    db.close()
    return results