Stuff

<?php

$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
");

?>