join('coach C','S.id = C.skill_id') ->where(['C.id'=>$coachId]) ->field('S.id,S.name') ->select()->toArray(); array_unshift($lists,['id'=>0,'name'=>'全部']); return $lists; } /** * @notes 商品详情 * @param $id * @return array * @author cjhao * @date 2024/11/27 14:41 */ public function detail($id) { $result = Goods::where('id',$id) ->withoutField('update_time,delete_time') ->append(['category_desc','goods_image']) ->findOrEmpty() ->toArray(); $result['virtual_order_num'] = $result['virtual_order_num'] + $result['order_num']; $goods_image = []; foreach ($result['goods_image'] as &$image) { $goods_image[] = $image['uri']; } $result['goods_image'] = $goods_image; $result['skill_id'] = GoodsSkillIndex::where(['goods_id'=>$id])->column('skill_id'); return $result; } }