迅睿CMS框架是一款PHP8高性能·简单易用的CMS开源开发框架，基于MIT开源许可协议发布，免费且不限制商业使用，是免费开源的产品，以万端互联为设计理念，支持的微信公众号、小程序、APP客户端、移动端网站、PC网站等多终端式管理系统。
联系官方销售客服
1835022288
028-61286886
多表关联查询请教？
需要循环zone表信息，但要根据会员关联查询news表是否有发布过信息，必须在news发布过信息，才会显示zone的信息列表
{module module=zone join=news on=uid order=displayorder_desc,updatetime num=10} {/module}
求大侠给个代码
模板文件：URL地址：
{php $where=url_encode("uid int (select uid from dr_1_news)");} {module module=zone where=$where order=displayorder_desc,updatetime num=10} {/module}
<?php $rt = \Phpcmf\Service::M()->db->query("select uid from dr_1_news group by uid"); if ($rt) { $rows = $rt->getResultArray(); foreach ($rows as $t) { $uid.= $t['uid'].','; } print_r($uid); } ?> <br/><br/> {module module=zone IN_uid=$uid order=displayorder_desc,updatetime num=10} {$t.title}<br/> {/module}{$debug}
{php $where=url_encode("uid int (select uid from dr_1_news)");} {module module=zone where=$where order=displayorder_desc,updatetime num=10} {/module}系统故障!
{php $where=url_encode("uid int (select uid from dr_1_news)");} {module module=zone where=$where order=displayorder_desc,updatetime num=10} {/module}<?php $rt = \Phpcmf\Service::M()->db->query("select uid from dr_1_news group by uid"); if ($rt) { $rows = $rt->getResultArray(); foreach ($rows as $t) { $uid.= $t['uid'].','; } print_r($uid); } ?> <br/><br/> {module module=zone IN_uid=$uid order=displayorder_desc,updatetime num=10} {$t.title}<br/> {/module}{$debug}