Array of subqueries

res.sql

SELECT `me`.`id`, `me`.`parent_id`, `me`.`created`, `me`.`updated`, `me`.`type`, `me`.`name`, `me`.`contact_id` 
  FROM ( 
    SELECT `me`.`id`, `me`.`parent_id`, `me`.`created`, `me`.`updated`, `me`.`type`, `me`.`name`, `me`.`contact_id` 
      FROM `companies` `me` 
    WHERE `id` IN ( ( 
            SELECT `me`.`company_id` 
              FROM `user_roles` `me` 
            WHERE `user_id` = 'ARRAY(0x7fbb6072f818)' 
            GROUP BY `company_id`
           ), ( 
            SELECT `me`.`company_id` 
              FROM `user_actions` `me` 
            WHERE `user_id` = 'ARRAY(0x7fbb6072f338)' 
            GROUP BY `company_id`
           ) )
   ) `me`

subq.pl

sub companies {
    my $self = shift;

    my $user_id = $self->id;

    my $roles = $self->schema->user_roles->search({ user_id => $user_id },
        { group_by => 'company_id' })->get_column('company_id')->as_query;
    my $actions = $self->schema->user_actions->search({ user_id => $user_id },
        { group_by => 'company_id' })->get_column('company_id')->as_query;

    return $self->schema->companies->search(
        { 'id' => { -in => [$roles, $actions] } })->as_subselect_rs;
}