title: Creating a SQL friends table to store
body: <p>I have taken it on myself to create a site that allows users to add each other as friends and comment on each others posts. After looking into this I'm not sure exactly how to start. I have a posts and a users table.</p>
  
  <p>My question is how would I relate the databases to
  1.Check if user A has sent a friend request to user B?
  2.Store a value to indicate that they are friends?</p>
  
  <p>I've browsed around this site before posting but can't seem to understand how to carry this out. Pretty sure I'm just over complicating it. Could anyone explain the concept or how this works?</p>