[Fixed]-Django: do SQL join for getting row count

you can do this query:

from django.db.models import Count

>>> user = User.objects.filter(pk=some_id).annotate(num_followers=Count('followers'))

>>> user
[<User: someuser>]

>>> user[0].id
some_id

>>> user[0].num_followers
123