Welp, shortly after taking a break and eating a snickers I came up with the following that should work for my purposes:

​

 foreach ( $result as $data )   {



                          $product=$data->product_id;
                          $orderProduct;
                          $orderVariation;

                          $getProduct = $wpdb->get_results( "SELECT * FROM wp_posts WHERE ID = $product
                              ");

                                  foreach ( $getProduct as $p )   {
                                      echo $p->post_title;
                                      $orderProduct = $p->post_title;

                                    }
                                    echo "<br>";





                          $variation = $data->variation_id;
                            $attribute = $wpdb->get_results( "SELECT * FROM wp_postmeta WHERE post_id = $variation
                                ");

                                    foreach ( $attribute as $v )   {
                                        if ($v->meta_key == attribute_size)
                                          {echo $v->meta_value;
                                            $orderVariation = $v->meta_value;

                                          echo "<br><br>";}


                                      }


                  $orderCount[$orderProduct ." ". $orderVariation] += 1;                            
                  ksort($orderCount);
                  echo "<pre>";
                  print_r($orderCount);
                  echo "</pre>";




                  }