public function authenticate()
{       
    $this->authAdapter = new AuthAdapter($this->dbAdapter,'usertable','username','password'
    );  

    $this->authAdapter->setIdentITy($this->username)
                ->setCredential($this->password)
                ->setCredentialTreatment('MD5(?)');
    $result = $this->authAdapter->authenticate();
    return $result;
}

当我使用zf2和doctrine构建我的身份验证时,我创建了授权插件并自定义了 this adapter,用于传递额外的列进行身份验证.
你可能需要继续进行类似的指导.

$adapter = new AuthAdapter($db,'users','password','MD5(?)'
                           );

// get select object (by reference)
$select = $adapter->getDbSelect();
$select->where('active = "TRUE"');

// authenticate,this ensures that users.active = TRUE
$adapter->authenticate();

Reference

更改后,您的代码应该看起来像这样.

public function authenticate()
{       
    $this->authAdapter = new AuthAdapter($this->dbAdapter,'password'
    );  

    $select = $this->authAdapter->getDbSelect();
    $select->where('status= "1"');
    $this->authAdapter->setIdentity($this->username)
                ->setCredential($this->password)
                ->setCredentialTreatment('MD5(?)');
    $result = $this->authAdapter->authenticate();
    return $result;
}