不能用left join了,这个一会变多条数据
正确的写法是把一先查出来,在用ID循环查出多的数据放到一的某字段中
栗子:
public function voucherList ($supplyID){
$data = M('mvoucher')
->where(['fdlSupplyID'=> $supplyID])
->select();
foreach ($data as $key => $value) { //放在condition里面的写法是[$key]['condition'], key前面要加$data
$data[$key]['condition'] = M('mvouchercondition')
->where(['fdlVoucherID'=> $value['ID']])
->select(); //拿ID这个值的写法是$value['ID'],key前面才要加$data
}
return $data;
}
正确的写法是把一先查出来,在用ID循环查出多的数据放到一的某字段中
栗子:
public function voucherList ($supplyID){
$data = M('mvoucher')
->where(['fdlSupplyID'=> $supplyID])
->select();
foreach ($data as $key => $value) { //放在condition里面的写法是[$key]['condition'], key前面要加$data
$data[$key]['condition'] = M('mvouchercondition')
->where(['fdlVoucherID'=> $value['ID']])
->select(); //拿ID这个值的写法是$value['ID'],key前面才要加$data
}
return $data;
}