SQL: SELECT main.*, mu.*, a.albumname as albumname, a.albumfengmian as albumfengmian FROM uchome_musicbox_mybox as main left JOIN uchome_musicbox as mu ON( main.boxsongid=mu.songid ) left JOIN uchome_musicbox_album as a ON ( mu.albumid = a.albumid ) WHERE main.page=1 AND main.boxuserid=5962