Magento List Categories and Subcategories which has Include in Navigation Menu as yes

List all categories and subcategories which has Include in Navigation Menu as yes

$collection = Mage::getResourceModel('catalog/category_collection')
    //only active categories
    ->addAttributeToFilter('is_active', 1) 
    //categories included in menu
    ->addAttributeToFilter('include_in_menu', 1) 
    ->addAttributeToSelect('*');

foreach ($collection as $category) {
    //do something with $category

     echo $category->getSku();
}