如何将带有外键的django模型导出到csv

import csv
from django.http import HttpResponse
from django.contrib import admin

def export_to_csv(request):
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="data.csv"'

    writer = csv.writer(response)
    writer.writerow(['Field1', 'Field2', 'ForeignKeyField'])

    # 获取带有外键的模型数据
    queryset = MyModel.objects.select_related('ForeignKeyField').all()

    for obj in queryset:
        writer.writerow([obj.field1, obj.field2, obj.ForeignKeyField.field])

    return response

from django.urls import path

urlpatterns = [
    path('export/', export_to_csv, name='export_to_csv'),
]