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

Question

微擎系统 下面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}";

Answer 1

$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 ");