如何使用Django和MySQL从每个组中选择最新的对象？

from django.db.models import Max
from .models import GroupObject

def get_latest_objects_from_each_group():
    # 获取每个组的最新对象的创建时间
    latest_objects = GroupObject.objects.values('group_id').annotate(latest_created_time=Max('created_time'))

    # 存储每个组的ID和最新对象的创建时间
    group_latest_objects = {}

    for obj in latest_objects:
        group_id = obj['group_id']
        latest_created_time = obj['latest_created_time']

        # 根据组ID和最新对象的创建时间，获取对应的最新对象
        latest_object = GroupObject.objects.filter(group_id=group_id, created_time=latest_created_time).first()

        # 存储每个组的ID和最新对象
        group_latest_objects[group_id] = latest_object

    return group_latest_objects