# get a hash ref keyed to id
my $data = $dbh->selectall_hashref(
    'select id, name, parent from category', 'id'
);