Выборка всех дочерних групп для группы

function getChildrenGroups($shop_id, $shop_group_id)
{
   $aReturn = array();
   $oCurrent_Shop_Group = Core_Entity::factory('Shop_Group', $shop_group_id);
   
   $oShop_Groups = $oCurrent_Shop_Group->Shop_Groups;
   $oShop_Groups->queryBuilder()->where('shop_id', '=', $shop_id);
   
   $aShop_Groups = $oShop_Groups->findAll();
   foreach ($aShop_Groups as $oShop_Group)
   {
      $aReturn[] = $oShop_Group;
      $aReturn = array_merge($aReturn, getChildrenGroups($shop_id, $oShop_Group->id));
   }
   
   return $aReturn;
}

$shop_group_id = 0;
$shop_id = 1;
$aChildrenGroups = getChildrenGroups($shop_id, $shop_group_id);
foreach ($aChildrenGroups as $oShop_Group)
{
   echo '<br />id = ', $oShop_Group->id;
}

function getChildrenGroups($informationsystem_id, $informationsystem_group_id)
{
   $aReturn = array();
   $oCurrent_Informationsystem_Group = Core_Entity::factory('Informationsystem_Group', $informationsystem_group_id);
  
   $oInformationsystem_Groups = $oCurrent_Informationsystem_Group ->Informationsystem_Groups;
   $oInformationsystem_Groups->queryBuilder()->where('informationsystem_id', '=', $informationsystem_id);
  
   $aInformationsystem_Groups = $oInformationsystem_Groups->findAll();
   foreach ($aInformationsystem_Groups as $oInformationsystem_Group)
   {
      $aReturn[] = $oInformationsystem_Group;
      $aReturn = array_merge($aReturn, getChildrenGroups($informationsystem_id, $oInformationsystem_Group->id));
   }
  
   return $aReturn;
}

$informationsystem_group_id = 0;
$informationsystem_id = 1;
$aChildrenGroups = getChildrenGroups($informationsystem_id, $informationsystem_group_id);
foreach ($aChildrenGroups as $oInformationsystem_Group)
{
   echo '<br />id = ', $oInformationsystem_Group->id;
}

function getChildrenGroups($informationsystem_id, $informationsystem_group_id)
{
   $aReturn = array();
   $oCurrent_Informationsystem_Group = Core_Entity::factory('Informationsystem_Group', $informationsystem_group_id);
  
   $oInformationsystem_Groups = $oCurrent_Informationsystem_Group ->Informationsystem_Groups;
   $oInformationsystem_Groups->queryBuilder()->where('informationsystem_id', '=', $informationsystem_id);
  
   $aInformationsystem_Groups = $oInformationsystem_Groups->findAll();
   foreach ($aInformationsystem_Groups as $oInformationsystem_Group)
   {
      $aReturn[] = $oInformationsystem_Group;
      $aReturn = array_merge($aReturn, getChildrenGroups($informationsystem_id, $oInformationsystem_Group->id));
   }
  
   return $aReturn;
}

$informationsystem_group_id = $Informationsystem_Controller_Show->group;
$informationsystem_id = Core_Array::get(Core_Page::instance()->libParams, 'informationsystemId');
$aChildrenGroups = getChildrenGroups($informationsystem_id, $informationsystem_group_id);
$in = array($Informationsystem_Controller_Show->group);
foreach ($aChildrenGroups as $oInformationsystem_Group)
{
   $in[] = $oInformationsystem_Group->id;
}

$Informationsystem_Controller_Show->group(FALSE);
$Informationsystem_Controller_Show
    ->informationsystemItems()
    ->queryBuilder()
    ->where('informationsystem_items.informationsystem_group_id', 'IN', $in);

      // Новости
      $Informationsystem_Controller_Show = new Informationsystem_Controller_Show(
         Core_Entity::factory('Informationsystem', 1)
      );
      $Informationsystem_Controller_Show
         ->xsl(
            Core_Entity::factory('Xsl')->getByName('СписокНовостейНаГлавной')
         )
         ->groupsMode('none')
         ->itemsForbiddenTags(array('text'))
         ->group(FALSE)
         ->limit(3)
         ->show();

$oInformationsystem = Core_Entity::factory('Informationsystem', Core_Array::get(Core_Page::instance()->libParams, 'informationsystemId'));

$Informationsystem_Controller_Show = new Informationsystem_Controller_Show($oInformationsystem);

$Informationsystem_Controller_Show
   ->limit(Core_Array::get(Core_Page::instance()->libParams, 'itemsOnPage'))
   ->parseUrl();

echo $Informationsystem_Controller_Show->group;