$multisigorta = array(1,2,3); 
$multiindirim = array(2,3); 

foreach($multisigorta as $deger){
    $sql_firma[] = 'kamp_firma LIKE %'.$deger.'%';
}

foreach($multiindirim as $deger){
    $sql_indirim[] = 'kamp_meslek LIKE %'.$deger.'%';
}

$sql = 'SELECT * FROM kampanya WHERE sonlanma > '.date("Y-m-d").' AND '.implode(" AND ", $sql_firma).' AND '.implode(" AND ", $sql_indirim).' ORDER BY sonlanma ASC';


$Kampanya=$SP_DB->Cok($sql);