SQL table(s) to get desired output in PHP [closed]

I have a PHP table in this format:

$Output = array ( 'strSMD' => array ( 'name' => 'blabla', 'server' => 'https:/blabla.com', 'profile' => 'https://blabla.com/Search.aspx?query=My+Name', 'profiletext' => "<li class=\"smd\">My profile at Bla Bla</li>", 'linktext' => "<li class=\"smd\">Buy from Bla Bla</li>" ), 'strSMP' => array ( 'name' => 'someother', 'server' => 'https://someother.com', 'profile' => 'https://www.someother.com/my-name/', 'profiletext' => "<li> Some other text....</li>", 'linktext' => "<li>Just another text</li>" ), 'strMN' => array( 'name' => 'onemore', 'server' => 'https://www.onemore.com', 'profile' => 'https://www.onemore.com/profile/my-name/', 'profiletext' => "<li> One More text</li>", 'linktext' => "<li"> One more linktext</span></li>" ), //etc );

Now I want to put it in a database. I thought about two tables, one with vendorcodes (strSMD, etc.) and one with vendor info (name, server, etc.) But I can't find out a query that gives this output array in PHP. Join gives me a flat array with the vendorcodes as array value. Does anybody have thoughts about a structure/query?