django 两表联查

models.py

class Order(models.Model):
    order_sn = models.CharField('订单号',max_length=50)
    user = models.ForeignKey('User',verbose_name='用户')
    express_sn = models.CharField('快递单号',max_length=50,blank=True)

class Order_Good(models.Model):
    o = models.ForeignKey('Order',verbose_name='订单')
    g_name = models.CharField('商品名',max_length=50)

views.py

select o.order_sn,o.express_sn,og.g_name from order o left join order_good og on o.id=og.o_id where o.user_id=5

or 
orderGoodList = Order_Good.objects.filter(o__user=5).values_list('o__order_sn','o__express_sn','g_name')