u014445884的专栏

//sql ALTER TABLE `tb_tx` ADD CONSTRAINT `id_uid` FOREIGN KEY (`tb_tid`) REFERENCES `test`.`tb_user`(`tb_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

tb_user_organization (userid,organizationid);//组织用户表 tb_user(id,name,sex);//用户表 查询与某个用户在同一个组织内的所有用户$demo=M("table"); $list=$demo->table('tb_user_organization a,tb_user b')->where("a.userid=b.id and a.o