我正在存储CPTproducts\' 将ID发布到CPT中companies\' post meta（meta\\U键=prefix_products). 因为一个公司可以有多个产品，所以我将它们存储到PHP序列化数组值中。

s:48:"a:3:{i:0;s:3:"334";i:1;s:3:"333";i:2;s:3:"331";}";

其中334、333、331是post类型的三个post\\U IDproducts.

我需要获取CPT的post\\u idcompanies 其中产品id（CTP的post\\U idproducts) 等于331（动态-可以是任何值）。它应该与meta\\u键的meta\\u值进行比较prefix_products.

我可以使用meta\\u值获取post\\u id，但我无法将数据存储为序列化数据(

到目前为止，我所做的还没有找到解决方案：

function get_company_of_the_product( $product_id ) {
    global $project_prefix;
    $prod_meta_key = $project_prefix .\'products\';

    $companies = get_posts( array(
            \'post_type\'     => \'companies\',
            \'post_status\'   => \'publish\',
            \'meta_key\'      => $prod_meta_key
        ) );
    $products_array = array();
    foreach ( $companies as $company ) {
        $products = get_post_meta( $company->ID, $prod_meta_key, true );
        $products_array[$company->ID] = unserialize( $products );
        //if( in_array( $product_id, $products_array ) ) return $company->ID; //I know it\'s wrong
    }

    var_dump($products_array);
}

是这样，还是我错过了一些很容易的事情？我怎样才能解开这个谜语？

function get_all_companies_selling( $product_id ){
    global $wpdb;
    $sql = "select post_id from " . $wpdb->prefix . "postmeta where
        meta_key = \'prefix_products\' &&
        meta_value like \'%%%s%%\'";

    $product_id = \'s:\' . strlen( $product_id ) . \':"\' . (int) $product_id . \'";\';
    $sql = $wpdb->prepare( $sql, $product_id );
    $res = $wpdb->get_results( $sql );

    return $res;
}

get_all_companies_selling( 331  );

$some_product_id = \'123\';
$args= array(
  \'post_type\' => \'companies\',  // only search postmeta of these cpts
  \'posts_per_page\' => 5,  // limit or not depending on your use
  \'orderby\' => \'date\',  // use whatever order you like
  \'meta_query\' => array(
    array(
    \'key\' => \'prefix_products\', // name of custom field
    \'value\' => \'"\' . $some_product_id . \'"\', // matches exactly "123" not just 123.
    \'compare\' => \'LIKE\'
  )
);

$the_related_companies = new WP_Query( $args );

if( $the_related_companies->have_posts() ) :
  <div class="container">
  while( $the_related_companies->have_posts() ) :
    [do stuff with your posts]
  endwhile;
  </div>
endif;