my $rs = $schema->resultset('Addons')->search(
     {
        join         => 'gb_invoices',

     },
);
 
##</code><code>##

SELECT * FROM addons
  LEFT JOIN gb_invoices ON gb_invoices.cp_id = addons.addon_id