创建一个具有不同课程的用户并显示它

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')

# 创建游标对象
cursor = cnx.cursor()

# 查询用户表和课程表，获取用户信息和所选课程信息
query = "SELECT users.username, courses.course_name, courses.course_description, courses.course_link " \
        "FROM users " \
        "JOIN courses ON users.course_id = courses.course_id"

# 执行查询
cursor.execute(query)

# 获取查询结果
results = cursor.fetchall()

# 遍历结果并显示用户信息和所选课程信息
for row in results:
    username = row[0]
    course_name = row[1]
    course_description = row[2]
    course_link = row[3]
    
    print("用户名:", username)
    print("课程名称:", course_name)
    print("课程描述:", course_description)
    print("课程链接:", course_link)

# 关闭游标和数据库连接
cursor.close()
cnx.close()