title: Filed in SQLAlchemy of user's list
body: <p>I have one model that is Users in which there is a field in this model that I would like to store a list of Users. The idea is that you can add frieds and store them somewhere.</p>
  
  <pre><code>class User (db.Model):
      __tablename__ = "users"
  
      id = Column(Integer, primary_key=True)
      username = Column(String(50), unique = True)
      email = Column(String(120), unique = True)
      password = Column(String(50))
      date = Column(DateTime(), default=datetime.now())
      friends = "Should be a list of users"
  </code></pre>
  
  <p>I have thought to have a string with the id of each user but, is there any posibility to do it with a relationship to the same model? like this:</p>
  
  <pre><code>friends = relationship("User")
  </code></pre>
  
  <p>Thanks a lot!</p>