javascript - Add up to 5 select fields based on a mysql created select form -

i have pretty complex form user data entered mysql database. user's role can either manager or assistant. want create link between manager , assistant. manager can have more 1 assistants. assistant can work more 1 manager.

i got far can reveal select line based upon role. if role manager, select line created users assistant role in mysql database , vise versa.

this works fine, how can create new field 5 assistants (or managers) clicking button , in such way again generates select line database, , minus user(s) selected?

for revealing of correct field using script:

<script type="text/javascript" src="//code.jquery.com/jquery-1.9.1.js"></script>  <script type='text/javascript'>//<![cdata[ $(window).load(function(){ $('#role').on('change', function() {   var selection = $(this).val();   switch (selection) {     case "manager":       $("#assistant").show()       $('#manager').hide()       break;     case "assistant":       $("#manager").show()       $("#assistant").hide()       break;     default:       $("#manager").hide()       $('#assistant').hide()   } });  });//]]>  

the select field created this:

<td><select name="linkmgr[]" id="manager" style="display:none;"><option selected="selected"></option> <?php $connmgr = new mysqli('localhost', 'admin', 'password', 'db')  or die ('cannot connect db');      $resultmgr = $connmgr->query("select id, full_name userdata role='manager' order full_name");         while ($rowmgr = $resultmgr->fetch_assoc()) {                    unset($idmgr, $fullname_mgr);                   $idmgr = $rowmgr['id'];                   $fullname_mgr = $rowmgr['full_name'];                   echo '<option value="'.$idmgr.'">'.$fullname_mgr.'</option>';  } ?></select></td> 

at moment, form nicely enters user-id of assistant (or manager) database. want comma separate data database when more 1 assistant (or manager) selected. have figured out already.

both fields created similarly. hope explained enough accomplish , showed crappy programming sufficiently guide me in right direction.

thanks!

basicly, looking at, many - - many database relation. more of propper aproach requare 3 tables (one managers, 1 assistants , 1 manage relations (table of unique pairs of managers , assistants working togethor)), , propper foreign keys set. cant give more detail, hope leed on right track:)