$ref = $sth->fetchall_arrayref();
$ref = [
        ['test1', 1],
        ['test2', 2]
       ];

##</code><code>##

$ref = [
        {data => 'test1', ID => 1},
        {data => 'test2', ID => 2}
       ];