select id, name from partners
union all
select id, site from partners
<?php
$tmp = [];
foreach ($partners as $item) {
$tmp[] = [ 'id' => $item['id'], 'name' => $item['name'], ];
$tmp[] = [ 'id' => $item['id'], 'site' => $item['site'], ];
}
insert into table2 (select distinct ... from table 1);
в случае если структура сложная - можно вместо distinct использовать group bydrop table1;
mysql_query($data1,$query1);