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

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();

}

        $select = DB::raw('count(settlementAmount) as settlementAmount');

        $res = self::where('id','>','1')->select($select)->orderBy('clickTime','desc')->groupBy('groupName')->paginate(20);