Rsa97

SELECT ...
  FROM `product`
  WHERE `id` IN (
    SELECT `product_id`
      FROM `product_option_values`
      WHERE `option_id` = 1
        AND `option_value_id` IN (1, 4)
  ) AND  `id` IN (
    SELECT `product_id`
      FROM `product_option_values`
      WHERE `option_id` = 4
        AND `option_value_id` IN (7)
  );

$result = implode(
  '',
  array_unique(
    array_merge(
      preg_split('//u', 'abce', -1, PREG_SPLIT_NO_EMPTY),
      preg_split('//u', 'cbegdy', -1, PREG_SPLIT_NO_EMPTY)
    )
  )
);

const isOverlap = (arr1, arr2) => arr1.some((el) => arr2.includes(el));
console.log(isOverlap([20, 50], [50, 100]));
// true

<?php
$array = [
    253 => 'я',
    189 => 'c',
    185 => 'в',
    298 => 'finish'
  ];
$arrgs = [];
$curr = &$arrgs;
foreach ($array as $idx => $val) {
    if (!array_key_exists($idx, $curr)) {
        $curr[$idx] = [];
    }
    $curr = &$curr[$idx];
}
$curr = $val;
print_r($arrgs);
//Array(
//  [253] => Array(
//    [189] => Array(
//      [185] => Array(
//        [298] => finish
//      )
//    )
//  )
//)