tp5.1中mysql查询根据字段判断

aModel::where('id',$id)->field('id,name',if(is_open=1,'公开','私密') as type)->order('sort')->select();