Drupal → Программно вывести термины словаря в виде дерева с подсчётом количества материалов

/**
 * Return rendered taxonomy tree
 */
function mymodule_taxonomy_tree_output($vid) {
  $terms = db_query("
    SELECT td.tid, td.name, th.parent, (
      SELECT COUNT(*) FROM {taxonomy_index} ti
      LEFT JOIN {node} n ON ti.nid = n.nid
      WHERE ti.tid = td.tid AND n.status = 1
    ) node_count FROM {taxonomy_term_data} td
    INNER JOIN {taxonomy_term_hierarchy} th ON th.tid = td.tid
    WHERE vid = :vid
    ORDER BY weight
  ", array(':vid' => $vid))->fetchAll();
 
  return theme('item_list', array('items' => mymodule_taxonomy_tree_format_terms($terms)));
}
 
/**
 * Format terms in tree.
 */
function mymodule_taxonomy_tree_format_terms($terms, $parent = 0, &$node_count = 0) {
  $items = array();
  $node_count = 0;
 
  foreach ($terms as $term) {
    if ($term->parent == $parent) {
      $children = mymodule_taxonomy_tree_format_terms($terms, $term->tid, $childs_node_count);
      $node_count_current = $term->node_count + $childs_node_count;
      $node_count += $node_count_current;
      $items[] = array(
        'data' => l($term->name, 'catalog/' . $term->tid) . ' (' . $node_count_current . ')',
        'children' => $children,
      );
    }
  }
 
  return $items;
}

echo mymodule_taxonomy_tree_output(1);