微擎小程序sql,如何关联读取

微擎系统 下面SQL语句,如何读取(表名:ccshop_comshop_member)中的 telphone 字段

表名:ccshop_comshop_member 与 表名:ccshop_comshop_order 关联系字段 user_id

$sql = "select o.order_id,o.type,os.name as status_name from ".tablename('ccshop_comshop_order')." as o , {$join} 
           ".tablename('ccshop_comshop_order_status')." as os 
              where  o.uniacid=:uniacid and o.order_status_id = os.order_status_id {$where}  
              order by o.date_added desc limit {$offset},{$size}";

图片说明

$sql = "SELECT telphone FROM ".tablename('ccshop_comshop_member');
pdo_fetchall("SELECT * FROM " . tablename('ccshop_comshop_member') . " as ug left join ".tablename('ccshop_comshop_order')." as g on ug.user_id = g.user_id ");