$pidList = $this->configurationManager->getConfiguration(
    \TYPO3\CMS\Extbase\Configuration\ConfigurationManagerInterface::CONFIGURATION_TYPE_FRAMEWORK
)['persistence']['storagePid'];
//$pidList contains comma separated list of PIDs: 40,39,56,55
// uses tt_content's "pages" and "recursive" settings