Как связать таблицы?

$query3 =$this->db->query("UPDATE oc_product_attribute SET title = '".$tab."' WHERE `product_id` ='".$product_id."' AND `attribute_id`=(SELECT MAX(attribute_id)  FROM oc_attribute_description)");
$query4 = $this->db->query("UPDATE oc_product_attribute SET attribute_id =(SELECT oc_attribute.attribute_id FROM oc_attribute, oc_product_attribute WHERE oc_attribute.text = oc_product_attribute.title )");

public function getProductAtr_parser($product_id, $products1,$products2) {
                    
foreach($products2 as $atr2 ){
        $query2 = $this->db->query("INSERT INTO oc_product_attribute(`product_id`, `attribute_id`, `language_id`, `text`,`title`) VALUES ('".$product_id."',NULL,'2','".$atr2."','0')");
 
        }
 
            foreach ($products1 as $atr1 => $tab) {
                        @$query1 = $this->db->query("INSERT INTO oc_attribute_description(`attribute_id`, `language_id`, `name`) VALUES ('','2','".$tab."')");
                        @$query = $this->db->query("INSERT INTO oc_attribute (`attribute_id`, `attribute_group_id`, `sort_order`,`text`) VALUES ('','1',(SELECT MAX(attribute_id) +1 FROM oc_attribute_description),'".$tab."')");
                        $query3 =$this->db->query("UPDATE oc_product_attribute SET title = '".$tab."' WHERE `product_id` ='".$product_id."' AND `attribute_id`=(SELECT MAX(attribute_id)  FROM oc_attribute_description)");
                        $query4 =$this->db->query("UPDATE oc_product_attribute SET attribute_id = '".$tab."' WHERE `product_id` ='".$product_id."' AND `attribute_id`=(SELECT MAX(attribute_id)  FROM oc_attribute_description)");
            }           
        
    }