title: MySQL : How to identify users I follow or follow me from other person's followers?
body: <p>I'm trying to create a twitter like follow/following system. The table design is like this -</p>
  
  <pre><code>leader_id | following_id | is_mutual
          1 |            2 | 1 // Mutually follow each other
          2 |            1 | 1
          1 |            3 | 0 
          1 |            4 | 1
          4 |            1 | 1
  </code></pre>
  
  <p>Let's say I'm <code>user_id=4</code>. I'm viewing the followers of <code>user_id=1</code>. I'll see the list -</p>
  
  <pre><code>2
  3
  4 -&gt; me
  </code></pre>
  
  <p>How can I determine which of these users I'm following or follow me. I'm looking to write a Laravel Eloquent statement for this. Even MySQL query would help me figure out the right way to do this.</p>