MYSQL中根据字段值判断返回不同的值

原生SQL写法：

select case 
  when total > max then 2 
  when total < min then 1 
else 0
end
from ta 

PHP(ThinkPHP)写法：

$data = Db::connect('data')->name("pay-{$date}")
   ->where($where)
   ->order('id', 'desc')
   ->limit(($page - 1) * 50, 50)
   ->field('id,case when payType=1 then "支付宝" when payType=2 then "微信" else "未知" end as payType')
   ->select();