mysql 左联 右联

select * from core_pages left join core_categories on core_pages.cid = core_categories.id where fid=1

select * from core_pages right join core_categories on core_pages.cid = core_categories.id where fid=1

public function getPagebyfid()
{
$select = $this->select()->setIntegrityCheck(false);
$select->from('core_pages', '*');
$select->join('core_categories', 'core_pages.cid = core_categories.id','');
return $result=$this->fetchAll($select);
}

结果

[0] => Array
	(
	[id] => 6
	[cid] => 3
	[uid] => 0
	[title] => 突破最薄极限 -- vivo X3 体验
	[body] => 2013年的手机市场犹如展开了一场“轻薄挑战 ”，手机轻薄已经是多年的热点话题，例如九年前的摩托罗拉 V3，凭借金属外壳和轻薄机身，销售量突破1.3亿台。如今的全触控智能手机少了以前实体键盘厚度所约束的硬件限制
	[status] => 1
	[createtime] => 1395517893
	[updatetime] => 0
	[comment] => 0
	[star] => 0
	[top] => 0
	[type] =>
	)
	[1] => Array
	(
	[id] => 9
	[cid] => 3
	[uid] => 0
	[title] => MIUI V5 加持 MTK -- 红米手机快速上手
	[body] => 七月底，小米公司发布了一款名为红米的手机，与此同时这台机也引发了各种各样的热议。而其根源应该就是其799的定价吧，木头对于一台799的手机能够给用户带来怎样体验也是充满好奇，刚好近日编辑部收到一台红米手机，于是就拿来试了一试，简单与大家分享一下。
	[status] => 1
	[createtime] => 1378173793
	[updatetime] => 0
	[comment] => 0
	[star] => 0
	[top] => 0
	[type] =>
	)
	[2] => Array
	(
	[id] => 7
	[cid] => 4
	[uid] => 0
	[title] => 变焦 ▪ 影像革命 -- Lumia 1020 国行联通版上手体验
	[body] => 现在是凌晨十二点半，我刚拿到诺基亚 Lumia 1020 拍完了一些照片，来开始敲打这篇快速上手体验。而这篇文章，大家看到的时候应该是当天中午左右了。先来回顾一下被戏称为“奥利奥”手机的 Lumia 1020 的信息，与国际 ...
	[status] => 1
	[createtime] => 1378173228
	[updatetime] => 0
	[comment] => 0
	[star] => 0
	[top] => 0
	[type] =>
	)

意思:文章cid在分类表里有对应分类(id)的文章;

public function getPagebyfid()
{
$select = $this->select()->setIntegrityCheck(false);
$select->from('core_categories', '*');
$select->join('core_pages', 'core_pages.cid = core_categories.id','');
return $result=$this->fetchAll($select);
}

结果

[0] => Array
	(
	[id] => 3
	[fid] => 1
	[name] => 安卓
	[path] => 1,3
	)
	[1] => Array
	(
	[id] => 3
	[fid] => 1
	[name] => 安卓
	[path] => 1,3
	)
	[2] => Array
	(
	[id] => 4
	[fid] => 1
	[name] => 诺基亚
	[path] => 1,4
	)

意思是

分类id在文章表中有对应cid的分类;

[0] => Array
	(
	[id] => 3
	[fid] => 1
	[name] => 安卓
	[path] => 1,3
	)
	[1] => Array
	(
	[id] => 3
	[fid] => 1
	[name] => 安卓
	[path] => 1,3
	)
	[2] => Array
	(
	[id] => 4
	[fid] => 1
	[name] => 诺基亚
	[path] => 1,4
	)