~~~ $data=Db::table('tuan_goods')->alias('a')->leftJoin('tuan_category b','a.cate_id=b.cate_id')-> field('a.goods_id,a.goods_name,a.create_time,a.genre,a.goods_unit,convert(a.goods_price/100,decimal(10,2)) as goods_price,convert(a.goods_group_price/100,decimal(10,2)) as goods_group_price,goods_group_num,a.is_play,a.is_send,a.state,a.state_id,b.cate_id,b.cate_name') ->page($page,6)->order('a.create_time','desc')->select(); ~~~