// app/controllers/projects_controller
function index() {
	$this->loadModel('Category');
	$this->loadModel('Project');
	$this->loadModel('Image');

	$categories = $this->Category->find('all', array(
		'recursive' => 1
	));
}

// app/models/Project.php
class Project extends AppModel {
	var $name = 'Project';

	var $order = 'Project.sort ASC';

	var $belongsTo = array(
		'Category' => array(
			'className' => 'Category'
		)
	);

	var $hasMany = array(
		'Image' => array(
			'className' => 'Image',
			'order' => 'Image.sort ASC'
		)
	);

	var $virtualFields = array(
		'project_image_count' => "SELECT count(i.id) FROM images as i WHERE i.project_id = Project.id"
	);
}


// app/models/Category.php
class Category extends AppModel {
	var $name = 'Category';
	var $order = 'Category.id asc';

	var $hasMany = array(
		'Project' => array(
			'className' => 'Project',
			'order' => 'Project.sort ASC'
		)
	);
}