aklast/common/models/UserNetworkHidden.php

<?php

namespace common\models;

use common\components\ActiveRecord;

/**
 * This is the model class for table "{{%USER_NETWORK}}".
 *
 * @property string $USER_ID 会员ID
 * @property string $HIDDEN_USER_ID 隐藏会员ID
 */
class UserNetworkHidden extends \common\components\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return '{{%USER_NETWORK_HIDDEN}}';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'USER_ID' => '会员ID',
            'HIDDEN_USER_ID' => '隐藏会员ID',
        ];
    }

    /**
     * 获取隐藏会员列表
     * @param $userId
     * @return array
     */
    public static function fetchHiddenUser($userId)
    {
        $hiddenUsers = static::find()->select(['HIDDEN_USER_ID'])->where('USER_ID=:USER_ID', ['USER_ID'=>$userId])->asArray()->all();
        $hiddenUser = [];
        foreach($hiddenUsers as $hu){
            $hiddenUser[] = $hu['HIDDEN_USER_ID'];
        }
        return $hiddenUser;
    }
}