ekshopApi/app/common/model/user/GradeLog.php

<?php

namespace app\common\model\user;

use app\common\model\BaseModel;

/**
 * 用户会员等级变更记录模型
 */
class GradeLog extends BaseModel
{
    protected $name = 'user_grade_log';
    protected $pk = 'log_id';
    protected $updateTime = false;

    /**
     * 关联会员记录表
     */
    public function user()
    {
        return $this->belongsTo('app\\common\\model\\user\\User');
    }

    /**
     * 关联会员记录表
     */
    public function oldGrade()
    {
        return $this->belongsTo('app\\common\\model\\user\\Grade', 'old_grade_id', 'grade_id');
    }

    /**
     * 关联会员记录表
     */
    public function grade()
    {
        return $this->belongsTo('app\\common\\model\\user\\Grade',  'new_grade_id', 'grade_id');
    }

    public function getList($params)
    {
        $model = $this;
        if(isset($params['search']) && !empty($params['search'])){
            $model = $model->where('user.nickName', 'like', "%{$params['search']}%");
        }
        return $model->alias('log')->with(['user', 'oldGrade', 'grade'])
            ->join('user user', 'user.user_id = log.user_id','left')
            ->order(['log.create_time' => 'desc'])
            ->paginate($params);
    }
}