thinkphp 获取一级分类下所有商品

function index(){
$shop_cate_mod=D('shop_cate');
$cid = isset($_GET['cid']) && intval($_GET['cid']) ? intval($_GET['cid']) :0;
$shop_cate=$shop_cate_mod->field('id,title')->where("status=1")->order("sort_order ASC")->select();
$this->assign('shop_cate',$shop_cate);

$this->display();

}
我这样只能获取一级分类,不能获取一级分类下面的商品?

可以这样
$str = 'select id from tp_order_cat where parentid in (1,5,6)';//获取所有的1,5,6的所有下级分类

$need_list = D('tp_order_cat')->where('parentid in (1,5,6)')->select();//获取到的
$need_id_str = ''; //获取需要的子类id
foreach($need_list as $val){
$need_id[] = $val['id'];
}
$need_id_str = join(',', $need_id);
$where = "catid in ($need_id_str)";
$products = $this->order_model->where($where)->order($order.' '.$method)->limit('5')->select();

你可以这样 $str = 'select id from tp_order_cat where parentid in (1,5,6)';//获取所有的1,5,6的所有下级分类 $need_list = d('tp_order_cat')->where('parentid in (1,5,6)')->select();//获取到的  $need_id_str = ''; //获取需要的子类id foreach($need_list as $val){     $need_id[] = $val['id']; }  $need_id_str = join(',', $need_id); $where = "catid in ($need_id_str)"; $products = $this->order_model->where($where)->order($order.' '.$method)->limit('5')->select();这样就可以了！

你可以这样 $str = 'select id from tp_order_cat where parentid in (1,5,6)';//获取所有的1,5,6的所有下级分类$need_list = D('tp_order_cat')->where('parentid in (1,5,6)')->select();//获取到的 $need_id_str = ''; //获取需要的子类idforeach($need_list as $val){ $need_id[] = $val['id'];} $need_id_str = join(',', $need_id);$where = "catid in ($need_id_str)";$products = $this->order_model->where($where)->order($order.' '.$method)->limit('5')->select();这样就可以了！