CakePHP permissions view

gistfile1.sql

SELECT 
	perm.id,
	aco_child.alias as controller,
	aco_parent.alias as action,
	_create,_read,_update,_delete,
	requester.model as requester_type
FROM
	acos as aco_child
JOIN acos as aco_parent ON aco_child.id = aco_parent.parent_id
JOIN aros_acos as perm ON perm.id = aco_parent.id
JOIN aros as requester ON requester.id = perm.aro_id;