Search using dynamically created anchor href in laravel

I want to include a dynamicaly created anchor that links to a search page that displays all users from that company. Users are allowed to be affiliated with more than one company. The information is being pulled from a mysql database example:

John Doe is affiliated with:

• Pepsi Company
• Cold Drinks Inc Company
• Sports Drinks Company

John Doe is affiliated with:

<a href="search/useraffiliation1"> Pespi Company</a>
<a href="search/useraffiliation2"> Cold Drinks Inc Company</a>
<a href="search/useraffiliation3"> Sports Drinks Company</a>

1.Whats the best way to go about doing this.

2.Whats the best way to structure my database. Should I use a single column for each affiliation or put all the affiliations in one.

via Chebli Mohamed