data = Article.objects.annotate(username=F('user__username'),category_name=F('category__name')).values('id','title','username','category_name') print data.query
SELECT `article`.`id`, `article`.`title`, `user`.`username` AS `username`, `category`.`name` AS `category_name` FROM `article` INNER JOIN `user` ON ( `article`.`user_id` = `user`.`id` ) INNER JOIN `category` ON ( `article`.`category_id` = `category`.`id`