$Model = M('Artist'); $map['name'] = array('like','thinkphp%'); $Model ->join('think_work ON think_artist.id = think_work.artist_id') ->join('think_card ON think_artist.card_id = think_card.id') ->where($map) ->select();