<?php

$query = $this->Pagina->find()
    ->join([
        'table' => 'categorias',
        'alias' => 'c',
        'type' => 'LEFT',
        'conditions' => 'c.id = paginas.category_id',
    ]);