thinkcmf sql 包含sql函数处理方式

 $data = Db::name('city_village')->where($where)->
            field('convert(district_name using gbk) as district,convert(town_name using gbk) as town,convert(village_committee using gbk) as village,claim_time,company,id,special_village,name,claim,remarks,village_introduction,district_name,town_name,village_committee')
            ->order('district,town,village')->paginate(3902);

$parent_id=Db::name('portal_category')->where(['id'=>$id])->field('parent_id')->find();

 

field  相当于 select * from 表名 中的 *  也就是查询的字段