PHP/MYSQLi showing different information from same column in table?
<p>I am not sure how to formulate the question, so I didn't find anything useful enough regarding my problem.</p>

<p><a href="https://i.stack.imgur.com/nV3EL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nV3EL.png" alt="Database"></a>
1. In PRO(projects) I have 3 columns: "organizer", "partners", "other". I want to use information from table ORG(organisations) in all of these 3.  Also, I need to show more than one partner. Is it possible? For example, I have 
org:</p>

<p>name  |country|city         |</p>

<p>apple |shop   |fruits part  |</p>

<p>cherry|plate  |big          |</p>

<p>orange|plate  |little       |</p>

<p>banana|shop   |frozen fruits|
I want to show in view.php:</p>

<p>All projects:</p>

<p>name  |organizer|partner      |other   |place       |</p>

<p>salad |banana   |apple,cherry |orange  |plate,little|</p>

<p>salad2|banana   |apple        |orange  |plate       |</p>

<ol start="2">
<li>Info for place in PRO is taken from two tables, country and city. But country and city are also used by organisation. organisation's country doesn't equal project's country(for example, project takes place in London, but none of the participants'organisations are based in London).</li>
</ol>

<p>Are all of these things doable with what I already have?</p>

<p><a href="https://i.stack.imgur.com/43Lfx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/43Lfx.png" alt="what i have for now"></a></p>

<ol start="3">
<li>I get "circled" relationship thanks to country/city double usage, is it allowed?(my teacher said no or should be avoided -? I don't remember- and I got different opinions from web).</li>
</ol>