This function fetch a multiple row with parent from a table. See bellw format
App::CategorySet(NAME)->getRecursive();
For example:
$data = App::CategorySet('blog-cat')->getRecursive();
// Return value
/*
Array
(
[data] => Array
(
[0] => Array
(
[id] => 2
[adminref] => 1
[lastmodified] => 2012-12-13 10:08:41
[entrydate] => 2012-12-13 10:08:41
[pid] => 0
[image] =>
[title] => Applications
[path_1] => Applications
[path_2] => Applications
)
[1] => Array
(
[id] => 14
[adminref] => 1
[lastmodified] => 2013-04-11 11:19:00
[entrydate] => 2013-04-11 11:19:00
[pid] => 2
[image] =>
[title] => Addons
[path_1] => |___Addons
[path_2] => Applications>>Addons
)
[2] => Array
(
[id] => 13
[adminref] => 1
[lastmodified] => 2013-04-11 11:18:49
[entrydate] => 2013-04-11 11:18:49
[pid] => 2
[image] =>
[title] => Component
[path_1] => |___Component
[path_2] => Applications>>Component
)
[3] => Array
(
[id] => 1
[adminref] => 1
[lastmodified] => 2012-12-13 10:47:18
[entrydate] => 2012-12-13 10:47:18
[pid] => 0
[image] =>
[title] => Page Manager
[path_1] => Page Manager
[path_2] => Page Manager
)
[4] => Array
(
[id] => 16
[adminref] => 1
[lastmodified] => 2013-04-11 11:19:26
[entrydate] => 2013-04-11 11:19:26
[pid] => 1
[image] =>
[title] => Snip
[path_1] => |___Snip
[path_2] => Page Manager>>Snip
)
[5] => Array
(
[id] => 15
[adminref] => 1
[lastmodified] => 2013-04-11 11:19:14
[entrydate] => 2013-04-11 11:19:14
[pid] => 1
[image] =>
[title] => Static Page
[path_1] => |___Static Page
[path_2] => Page Manager>>Static Page
)
)
)
*/