Since the wp_brands is your own custom table, I would recommend passing the brand the user clicks on via Query String:
http://example.com/your/permalink/?brand=xyz
You can access this via PHP in your page template(not the wp-admin editor) like this:
$_GET['brand'];
Once you have that you can use whichever brand the user chose to query the database. This isn’t the “WordPress” way of doing things, but it will solve the issue.