[Fixed]-Django queryset of two models

Should add rename=True attribute to namedtuple call

namedtuple('Result', [col[0] for col in desc], rename=True)

You should use select_related and prefetch_related for these purposes.
When you want get table from related model, use ‘select_related’:

SocialAuthUsersocialauth.objects.select_related('user')  

When you want get all related tables, use ‘prefetch_related’:

AuthUser.objects.prefetch_relatd('socialauthusersocialauth_set')  

It will add to your querysets additional atribute, with name of related field. Also better add atribute related_name in ForeignKey for more explicit usage.