Return to Answer

Please try below collection.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$parentCategoryId = 2;
$parentCategory = $objectManager->get('Magento\Catalog\Model\Category')->load($parentCategoryId);


    $collection =$objectManager->create("\Magento\Catalog\Model\CategoryFactory")->create()->getCollection()->addAttributeToSelect('*')
                      ->setOrder('position', 'ASC')
              ->addFieldToFilter('is_active',array("in"=>array('0', '1')))
                     ->addAttributeToFilter('parent_id',['eq'=>$parentCategoryId]);

        print_r($collection->getData());

I Hope It's Will Helpful.

Please try below collection.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$parentCategoryId = 2;
$parentCategory = $objectManager->get('Magento\Catalog\Model\Category')->load($parentCategoryId);


    $collection =$objectManager->create("\Magento\Catalog\Model\CategoryFactory")->create()->getCollection()->addAttributeToSelect('*')
                      ->setOrder('position', 'ASC')
              ->addFieldToFilter('is_active',array("in"=>array('0', '1')))
                     ->addAttributeToFilter('parent_id',['eq'=>$parentCategoryId]);

        print_r($collection->getData());

I Hope It's Will Helpful.

Please try below collection.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$parentCategoryId = 3;
$parentCategory = $objectManager->get('Magento\Catalog\Model\Category')->load($parentCategoryId);


    $collection =$objectManager->create("\Magento\Catalog\Model\CategoryFactory")->create()->getCollection()->addAttributeToSelect('*')
                      ->setOrder('position', 'ASC')
              ->addFieldToFilter('is_active',array("in"=>array('0', '1')))
                     ->addAttributeToFilter('parent_id',['eq'=>$parentCategoryId]);

        print_r($collection->getData());

I Hope It's Will Helpful.

Please try below collection.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$parentCategoryId = 2;
$parentCategory = $objectManager->get('Magento\Catalog\Model\Category')->load($parentCategoryId);


    $collection =$objectManager->create("\Magento\Catalog\Model\CategoryFactory")->create()->getCollection()->addAttributeToSelect('*')
                      ->setOrder('position', 'ASC')
              ->addFieldToFilter('is_active',array("in"=>array('0', '1')))
                     ->addAttributeToFilter('parent_id',['eq'=>$parentCategoryId]);

        print_r($collection->getData());

I Hope It's Will Helpful.

Please try below collection.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$parentCategoryId = 2;
$parentCategory = $objectManager->get('Magento\Catalog\Model\Category')->load($parentCategoryId);


    $collection =$objectManager->create("\Magento\Catalog\Model\CategoryFactory")->create()->getCollection()->addAttributeToSelect('*')
                      ->setOrder('position', 'ASC')
                      ->addIdFilter($parentCategory->getChildren());
            
        print_r($collection->getData());

I Hope It's Will Helpful.

Please try below collection.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$parentCategoryId = 3;
$parentCategory = $objectManager->get('Magento\Catalog\Model\Category')->load($parentCategoryId);


    $collection =$objectManager->create("\Magento\Catalog\Model\CategoryFactory")->create()->getCollection()->addAttributeToSelect('*')
                      ->setOrder('position', 'ASC')
              ->addFieldToFilter('is_active',array("in"=>array('0', '1')))
                     ->addAttributeToFilter('parent_id',['eq'=>$parentCategoryId]);

        print_r($collection->getData());

I Hope It's Will Helpful.