查询id为键的数组

public static function getKeyValuePairs()
    {
        $sql = 'SELECT id, name FROM ' . self::tableName() . ' ORDER BY id ASC';

        return Yii::$app->db->createCommand($sql)->queryAll(PDO::FETCH_KEY_PAIR);
    }