export_facebook_users.py

import csv
from django.contrib.auth.models import User

fields = ['username', 'first_name', 'last_name', 'is_active', 'email', 'id', 'last_login', 'date_joined']
users = User.objects.filter(is_active=True, facebookprofile__isnull=False, child_of__isnull=True)
users = users.values_list(*fields)
user_count = users.count()

with open('users.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(fields)
    
    for idx, user in enumerate(users):
        writer.writerow(user)
        print(f'{idx}/{user_count}', end="")