tree, MySQL - rextester

Language: Layout:

drop table if exists some_table;
CREATE TABLE some_table(`ID` int, `TITLE` varchar(17), `CONTROLLER` varchar(10), `METHOD` varchar(17), `PARENT_ID` int);
INSERT INTO some_table(`ID`, `TITLE`, `CONTROLLER`, `METHOD`, `PARENT_ID`)VALUES
    (1, 'Dashboard', 'admin', 'dashboard', 0),
    (2, 'Content', 'admin', 'content', 0),
    (3, 'Modules', 'admin', 'modules', 0),
    (4, 'Users', 'admin', 'users', 0),
    (5, 'Settings', 'admin', 'settings', 0),
    (6, 'Reports', 'admin', 'reports', 0),
    (7, 'Help', 'admin', 'help', 0),
    (8, 'Pages', 'content', 'pages', 2),
    (9, 'Media', 'content', 'media', 2),
    (10, 'Articles', 'content', 'articles', 2),
    (11, 'Menues', 'content', 'menues', 2),
    (12, 'Templates', 'content', 'templates', 2),
    (13, 'Themes', 'content', 'themes', 2),
    (14, 'Blog', 'content', 'blog', 2),
    (15, 'Forum', 'content', 'forum', 2),
    (16, 'Core Modules', 'modules', 'core_module', 3),
    (17, 'User Modules', 'modules', 'user_module', 3),
    (18, 'All Users', 'users', 'all_users', 4),
    (19, 'Groups', 'users', 'groups', 4),
    (20, 'Permissions', 'users', 'permissions', 4),
    (21, 'Import and Export', 'users', 'import_export', 4),
    (22, 'Send Email', 'users', 'send_mail', 4),
    (23, 'Login Records', 'users', 'login_records', 4),
    (24, 'General Settings', 'settings', 'general_settings', 5),
    (25, 'Email Settings', 'settings', 'email_settings', 5),
    (26, 'Popular Content', 'reports', 'popular_content', 6),
    (27, 'Most Active Users', 'reports', 'most_active_users', 6),
    (28, 'Documentation', 'help', 'documentation', 7),
    (29, 'About', 'help', 'about', 7),
    (30, 'Products', 'products', 'product', 17),
    (31, 'Categories', 'categories', 'category', 17);

select version();

select *
from (
    select t.*,
        case when t.id = @pid 
            then (@pid := t.parent_id) + 1
            else 0
        end as filter
    from some_table t
    cross join (select @pid := 31)init
    order by id desc
) t
where filter > 0
order by id asc;

select t.*,
    case when t.id = @pid 
        then (@pid := t.parent_id) + 1
        else 0
    end as filter
from some_table t
cross join (select @pid := 31)init
having filter > 0
order by id desc;


absolute service time: 0,34 sec