在PeeWee对象模型中从父对象引用时如何排序子记录

from peewee import *

# 定义父对象模型
class Parent(Model):
    name = CharField()

# 定义子对象模型
class Child(Model):
    parent = ForeignKeyField(Parent, backref='children')
    name = CharField()
    age = IntegerField()

    class Meta:
        order_by = ('age',)  # 按年龄升序排序

# 连接数据库
database = SqliteDatabase('my_app.db')
database.connect()

# 创建表格
database.create_tables([Parent, Child])

# 创建父对象
parent = Parent.create(name='John')

# 创建子对象并关联到父对象
child1 = Child.create(parent=parent, name='Alice', age=25)
child2 = Child.create(parent=parent, name='Bob', age=20)
child3 = Child.create(parent=parent, name='Charlie', age=30)

# 通过父对象引用子记录，并按年龄排序
sorted_children = parent.children.order_by(Child.age)

# 打印排序后的子记录
for child in sorted_children:
    print(child.name, child.age)

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