Laravel5.4 关联模型查询,我应该要怎么查询才好???
第一条语句,查询出多个属性,然后每个属性里有多个属性详情,我这样子写有点慢,想用orm模型化,查询,请问应该要怎么写好呢????
$ProductAttr = ProductAttr::where('product_id', $product_id)->get(['product_attr_id','name']);
foreach ($ProductAttr as $value) {
$value->attrInfo()->detach($value['product_attr_id']);
$value['attrInfo'] = ProductAttrInfo::where('product_attr_id', $value['product_attr_id'])->get(['product_attr_info_id','name','preview','unit_price']);
}
推荐文章: