Django Rest Framework：关联两张表并嵌套返回参与者与对应地点数据

Hey there! Let's get this sorted out for you. You're looking to include all related Location entries as an array inside each Participant object when fetching your data—totally doable with a few small tweaks to your serializers and query logic. Here's how:

1. Update the Participant Serializer to Nest Locations #

Since your Location model uses related_name="locations" for the foreign key to Participant, you can directly add this relationship to your ParticipantSerializer using the LocationSerializer you already have. Just add a nested serializer field with many=True (since one participant can have multiple locations):

class ParticipantSerializer(serializers.ModelSerializer):
    # Add this line to include related Location data
    locations = LocationSerializer(many=True, read_only=True)

    class Meta:
        model = Participant
        fields = "__all__"

2. Fix the Location Serializer Configuration #

You have a small mistake in your LocationSerializer—you're trying to configure tax_policy inside the Meta class, which isn't valid. Move that setting to an extra_kwargs dict inside Meta, or define it as a top-level field. Here's the corrected version:

class LocationSerializer(serializers.ModelSerializer):
    class Meta:
        model = Location
        fields = "__all__"
        # Use extra_kwargs to set field-specific options
        extra_kwargs = {
            'tax_policy': {'allow_blank': True, 'allow_null': True}
        }

3. Optimize Query Performance in Your View #

To avoid the dreaded N+1 query problem (where Django makes a separate database call for each participant's locations), make sure to use prefetch_related("locations") in your view's queryset. For example, if you're using a ListAPIView:

from rest_framework.generics import ListAPIView

class ParticipantListView(ListAPIView):
    queryset = Participant.objects.all().prefetch_related("locations")
    serializer_class = ParticipantSerializer

Final Result #

With these changes, your API response will match exactly what you're looking for—each participant object will include a locations array containing all associated Location records, just like the JSON example you shared.

内容的提问来源于stack exchange，提问作者Tomer Avraham