title: How do I add data from parents to child table Postgres?
body: <p>I have 3 tables:</p>
  <p><a href="https://i.stack.imgur.com/okpPl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/okpPl.png" alt="enter image description here" /></a></p>
  <p>What I have: 2 pages;</p>
  <p>ONE where an admin can add a project's name and the id will be autogenerated and</p>
  <p>TWO (currently working on) Add and user with its name, ID to the USERS table, and select a project from the PROJECTS table, so after it gets added, display that info, either the users and the projects they belong to, or the projects and the users it contains.</p>
  <p>In this page I am already displaying the projects from the PROJECTS table in a checkbox, since they can belong to several projects, but I need to display: <em>userName</em>, <em>projectName</em> and probably later the IDs, in a table when they get added.</p>
  <p>How can I add that info to the child table and show the columns values from its parents tables? projectName and userName</p>
  <p>Any help and suggestions are highly appreciated.</p>
  <p>PS: I'm not good with databases so I'm probably missing something obvious here.</p>