$data = $this->Forum->query("SELECT `Forum`.*, `parent`.*, COUNT( * ) -1 AS level, `User`.`username` FROM `forums` AS `Forum`, `forums` AS `parent` LEFT JOIN `users` AS `User` ON (`Forum`.`lastpost_user_id` = `User`.`ID`) WHERE Forum.lft BETWEEN parent.lft AND parent.rgt GROUP BY Forum.lft ORDER BY Forum.lft");