现在有查询语句：
SELECT
users.sNmame,
users.iCreateTime,
users_ext.iAge,
users_ext.sSex
FROM
users
LEFT JOIN users_ext ON users.iAutoId = users_ext.iUserID
WHERE
users.iStatus = 1
AND users_ext.sSex = 0
ORDER BY
users.iCreateTime
LIMIT 0,
1
这里是简单的一个查询语句，接下来就以ORM的形式实现：
public function getUsers(){
$select = 'users.sNmame,users.iCreateTime,users_ext.iAge,users_ext.sSex';
$resData = UserModel::selectRaw($select)->leftJoin('users_ext','users.iAutoId','=','users_ext.iUserID')->where('users.iStatus','=',1)->where('users_ext.sSex','=',0)->skip(0)->limit(1)->get();
var_dump($resData->toArray());
exit();
}
ok ，以上只是对查询做了一个简单的例子，还有很多需要研究，比如模块之间的关联等等。
装配原生sql语句
$select = DB::raw('count(settlementAmount) as settlementAmount');
$res = self::where('id','>','1')->select($select)->orderBy('clickTime','desc')->groupBy('groupName')->paginate(20);
转：https://www.cnblogs.com/brudeke/p/4227711.html