插件帖子2帖子:如何在循环中显示从父帖子最新连接的子帖子？

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
cursor = cnx.cursor()

# 获取父帖子的信息
parent_post_id = 1  # 假设父帖子的ID为1
query = "SELECT latest_child_post_id FROM parent_posts WHERE id = %s"
cursor.execute(query, (parent_post_id,))
latest_child_post_id = cursor.fetchone()[0]

# 获取最新连接的子帖子的详细信息
query = "SELECT * FROM child_posts WHERE id = %s"
cursor.execute(query, (latest_child_post_id,))
child_post = cursor.fetchone()

# 在循环中展示子帖子信息
for child_post in child_posts:
    print("子帖子标题：", child_post[1])
    print("子帖子内容：", child_post[2])
    print("子帖子链接：", child_post[3])
    print("子帖子发布时间：", child_post[4])

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