LEFT JOIN is a very powerful MySQL command because it can cut down query counts exponentially when loading lots of information (no need to use the awful recursive query anymore).
Here's my attempt at your query:
That should do the trick.
SELECT appletype.name, appleinfo.color, appleorigin.location
LEFT JOIN `applelist` ON appletype.typeid = applelist.typeid
LEFT JOIN `appleinfo` ON applelist.infoid = appleinfo.infoid
LEFT JOIN `appleorigin` ON appleorigin.originid = appleinfo.originid
ORDER BY appletype.name