my $query = "SELECT id, display_name FROM membership ORDER BY display_name"; # use DESC if you don't want ASC order.
my $sth = $dbh->prepare($query);
...