Laravel: Eloquent Tips - maple-dev-team/docs GitHub Wiki

ProductInventory::select('product_inventories.*')
->join('products', 'products.id', '=', 'product_inventories.product_id')
->orderBy('products.name', 'ASC')
->get();