Question

用thinkphp框架连贯操作

原生SQL语句如下。query("SELECT fid,SUM(money)/1000 AS sss FROM `hx_user` GROUP BY fid ORDER BY sss DESC");用thinkphp框架连贯操作怎么实现

Answer 1

M('User')->field('fid,SUM(money)/1000 as sss')->group(' fid ')->order('sss desc')->select();