thinkphp5 使用unique自动验证账号是否已存在，好像数据表默认主键必须是id

如果主键不是id，会提示错误SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list'

解决办法，可以自定义主键id

但是，如果是软删除的话，可能还是会有问题，

所以最好还是自定义函数，验证账号是否存在

thinkphp5 validate自定义验证 添加和修改 传递参数主键id
https://taotaoit.com/article/details/1390.html

<?php
namespace app\admin\validate;
use think\Validate;
use think\Db;
/**
 * 职员验证器
 */
class Staff extends Validate{
  protected $rule = [
    'staffAccount' => 'require|checkStaffAccount:1',
    'staffPass' => 'require|min:5',
    'staffName' => 'require',
    'roleId' => 'require',
  ];
  protected $message = [
    'staffAccount.require' => '账号不能为空',
    'staffAccount.unique' => '账号已存在',
    'staffPass.require' => '密码不能为空',
    'staffPass.min' => '密码不能少于5个字符',
    'staffName.require' => '姓名不能为空',
    'roleId.require' => '角色不能为空',
  ];
  protected $scene = [
    'add' => ['staffAccount','staffPass','staffName','roleId'],
    'edit' => ['staffAccount','staffName','roleId'],
  ];
  protected function checkStaffAccount($value){       
    $where = [];
    $where['dataFlag'] = 1;
    $where['staffAccount'] = $value;
    $rs = Db::name('staff')->where($where)->count();
    return ($rs==0)?true:'账号已存在';
  }
}