How can I compare 2 tables in mysql and check the result
<p>I have two tables, one of them is for friends of a person and another one is for channel member.</p>

<p>I want to check if one of my friends is one of the channel members. If so don't show his name, else show him.</p>

<pre><code>$get_friend = "select * from friends where user_1_id='$user_id' AND friends_status=1";
$run_friend = mysqli_query($conn,$get_friend);

$select_members = "SELECT user_id from channel_members where channel_id='$channel_id'";
$run_members = mysqli_query($conn,$select_members);
</code></pre>