Joining on 3 different keys as they're set
Try this:

SELECT settings.* FROM vessels INNER JOIN settings ON setting.organization_id=vessel.id
UNION
SELECT settings.* FROM vessels INNER JOIN settings ON setting.fleet_id=vessel.id
UNION
SELECT settings.* FROM vessels INNER JOIN settings ON setting.vessel_id=vessel.id