SQL query for manufacturer images

[prestauser9]

I'm looking for an SQL query that can assign manufacturer images to category images.

So for example, my category menu is as follows:
____________
CATEGORIES |
____________|
MENU1---------->Submenu1_Manufacturer_1
____________|->Submenu1_Manufacturer_2
____________|->Submenu1_Manufacturer_3
.
_______________
MANUFACTURERS|
______________|
Manufacturer 1
_______________
Manufacturer 2
_______________

Is there an easy way, e.g. an SQL query, that I can use to link the images that appear when I click the
MANUFACTURERS hyperlink to the images that would normally appear when I click MENU1 hyperlink?

I'm using Prestashop 1.3.1.