my $clients = $get->fetchall_arrayref({});

##</code><code>##

my @ids = map { $_->{id} } @$clients;

##</code><code>##

my %client_for = map { $_->{id} => $_ } @$clients;
# $client_for->{1}->{lastname} ...