phpcms 调用副表

// 假设我们有一个新闻主表 news_main 和一个新闻副表 news_detail
// news_main 表结构：id, title, publish_time
// news_detail 表结构：id, news_id, content, author

// 获取主表数据
$main_data = pc_base::load_model('news_main_model')->select();

foreach ($main_data as $key => $value) {
    // 获取副表数据
    $detail_data = pc_base::load_model('news_detail_model')->select(array('news_id' => $value['id']));
    
    // 将副表数据合并到主表数据中
    $main_data[$key]['detail'] = $detail_data;
}

// 输出结果
print_r($main_data);

$detail_data = pc_base::load_model('news_detail_model')->select(array('news_id' => $value['id']));
if (empty($detail_data)) {
    echo "No detail data found for news ID: " . $value['id'];
}

// 使用索引和分页查询
$detail_data = pc_base::load_model('news_detail_model')->limit(10)->select(array('news_id' => $value['id']));