thinkphp支持query查询

$Model=M('greenschool');
return $Model->query("SELECT gs_patch, CASE gs_patch WHEN 1 THEN '第一批' WHEN 2 THEN '第二批' else '第三批' END as patchname from tsh_greenschool where gs_nationid =1 group by gs_patch");