$schema->resultset('CD')->search( .. 
      { prefetch => [ 'Author' ], 
        join => ['Categories'], 
        +select => ['categories.category_id' ],
        +as => ['categories.category_id' ],
        page => $page, 
        distinct => 1,
      } );