lizhi/application/common/model/NicknameAuth.php

<?php

namespace app\common\model;

use think\Model;

/**
 * 昵称审核
 */
class NicknameAuth Extends Model
{

    // 表名
    protected $name = 'nickname_auth';
    // 开启自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';
    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';

    public static function getAuthStatus($user_id,$nickname) {
        $status = self::where(['user_id'=>$user_id,'nickname'=>$nickname])->order("createtime","desc")->value("status");
        if(!in_array($status,[-1,1]) && $status !== 0) {
            $status = 1;
        }
        return $status;
    }

}