I'm wanting to fetch and group records from a database table by the first letter. So for example:

> 
> **A**  
> 
>  Alfred
> 
> 
> **B**  
> 
>  Brian
> 
> 
> **C**  
> 
>  Christopher
> 
> 
> ...
> 
> 
> 

Ideally, I'd like my data structure to come out as follows:

```
Array
(
    [A] => Array
    (
        [0] => Array
        (
            [Person] => Array
            (
                [id] => 12
                [name] => Alfred
            )
        )
    )
)

```

I could do this with a raw MySQL query, but not sure if CakePHP supports this out of the box. I'm just literally wanting records grouped so I can iterate over them and create an unordered list for each letter:

```
<h2>A</h2>
<ul>
  <li>Alfred</li>
</ul>
<h2>B</h2>
<ul>
  <li>Brian</li>
</ul>
<h2>C</h2>
<ul>
  <li>Christopher</li>
</ul>
...

```