How to change Laravel query?

$stock_qry=''; if ($this->configVal('outOfStock') == 2) { $stock_qry =" AND (( tyv.option_stock > 0 ) OR (p.enquiry=1 OR p.pb_sku!=''))"; }

SELECT option_name , GROUP_CONCAT(DISTINCT option_value ORDER BY CASE WHEN option_name IN('size') THEN option_value + 0 ELSE LENGTH(option_value) END) option_values FROM (SELECT tyv.id, parent_option_name option_name, parent_option_value option_value FROM product_attribute_values tyv, products p, categories ct WHERE p.category_id = '$primaryCategoryId' AND p.id = tyv.product_id AND p.active = 1 AND p.product_mapping_attribute_id > 0 $stock_qry AND ct.store_id = ".$this->storeId." AND ct.id = p.category_id UNION SELECT tyv.id, option_name, option_value FROM product_attribute_values tyv, products p, categories ct WHERE p.category_id = '$primaryCategoryId' AND p.id = tyv.product_id AND p.active = 1 AND p.product_mapping_attribute_id > 0 $stock_qry AND ct.store_id = ".$this->storeId." AND ct.id = p.category_id) x WHERE option_name IS NOT NULL GROUP BY option_name

How to modify this query to Laravel?

Thanks