Magento 2: Select Field From Collection Query

You need to reset all column first, then select specific column. Try following way:

$collection->getSelect()
            ->reset(\Zend_Db_Select::COLUMNS)
            ->columns(['id']);

You can also Try :

$collection = $this->_collectionFactory->create()->addFieldToSelect('id')->addFieldToFilter('status', 0)->load();