ThinkPHP 5.1中的链式查询

// 导入模型类use appcommonmodelUser;// 创建模型实例$userModel = new User();// 使用链式查询查询所有用户$users = $userModel->select();

$users = $userModel->where('status', 1)->select();

$users = $userModel->order('create_time', 'desc')->select();

$users = $userModel->limit(10)->select();

$users = $userModel->where('status', 1)                  ->where('age', '>', 18)                  ->join('profile p', 'p.user_id = user.id')                  ->field('user.id, user.username, p.email')                  ->select();