Сопостовление данных из двух таблиц

<?php
//подключение к бд $sql=mysqli_connect...
$q = "SELECT * FROM user";
$i = 0;
if ($result = $sql->query($q)) {
while ($row[$i] = $result->fetch_assoc()) {
$i++;
}
};
for ($i = 0, $k=count($row); $i<$k; $i++)
echo "<ul>";
if ($row[$i]['attach'] == true) {
$qw = "INSERT INTO user (attach) VALUES ('!$row[$i]['attach']')"
echo "<li>".$row[$i]['Provider']." - подключено";
echo "<form method=\"post\">";
echo "<input name=\"off\" type=\"submit\" value=\"отключить\">";
if(isset($_POST['off'])) {
$resoff = $sql->query($qw);
}
}
else {
echo "<li>".$row[$i]['Provider']." - отключено";
}
echo "</ul>";
 
?>

$adapter = mysql_query("
    SELECT provider
    FROM socialauth_adapter
    WHERE active = '1'
    ORDER BY provider DESC
");
while ($provider = mysql_fetch_array($adapter))
{
    $check = mysql_query("SELECT * FROM socialauth_user WHERE userid = '" . $userid . "' AND provider = '" . $provider['provider'] . "'");
    if ($check)
    {
        print 'This provider enable';
    } else {
        print  'This provider disable';
    }
}

"SELECT * FROM socialauth_user WHERE userid = '" . $userid . "' AND provider in 
(SELECT provider
    FROM socialauth_adapter
    WHERE active = '1'
    ORDER BY provider DESC)"