get customized array format in cakephp

Question

I have table name with TEST id name_id name 1 11 one 2 11 two 3 12 three 4 12 four 5 13 five

i need out put like follows with single query without foreach loop.

array( [11] => Array ( [TEST] => Array ( [name] => one )

    )

[11] => Array
    (
        [TEST] => Array
            (
                [name] => two
            )

    )

[12] => Array
    (
        [TEST] => Array
            (
                [name] => three
            )

    )

[12] => Array
    (
        [TEST] => Array
            (
                [name] => four
            )

    )
 [13] => Array
    (
        [TEST] => Array
            (
                [name] => five
            )

    ));

Answer 1

You can try putting the id with set::combine.

$data = set::combine(
    $this->TEST->find('all', array('fields' => array('name'))),
    '{n}.TEST.id',
    '{n}.TEST'
);