SELECT *
FROM foo
JOIN bar ON foo.id = bar.foo_id
JOIN baz ON foo.id = baz.foo_id
JOIN boink ON foo.id = boink.foo_id;