QQ

$sql = "SELECT * FROM `member` as m  LEFT JOIN `play` as r on m.mId = r.mId where m.mDoctor = ?";

$sth=$dbh->prepare($sql);

$sth->execute(array($mId));
  while ($result = $sth->fetch(PDO::FETCH_OBJ)) {
      print_r($result);
  }
  
-----
stdClass Object ( [mId] => [mAccount] => yihanlin [mPasswd] => 098f6bcd4621d373cade4e832627b4f6 [mLastName] => Yi Han [mFirstName] => Lin [mSex] => female [mDescription] => test [mHeight] => 170.5 [mWeight] => 95 [mBirthDay] => 1992-01-01 [mType] => patient [mDoctor] => 1 [lnTime] => [gId] => [pTime] => ) stdClass Object ( [mId] => [mAccount] => ggininder [mPasswd] => ggininder [mLastName] => ininder [mFirstName] => gg [mSex] => male [mDescription] => none [mHeight] => 178 [mWeight] => 99 [mBirthDay] => 1993-01-12 [mType] => patient [mDoctor] => 1 [lnTime] => [gId] => [pTime] => ) stdClass Object ( [mId] => [mAccount] => ggininder [mPasswd] => ggininder [mLastName] => ininder [mFirstName] => gg [mSex] => male [mDescription] => none [mHeight] => 178 [mWeight] => 99 [mBirthDay] => 1993-01-12 [mType] => patient [mDoctor] => 1 [lnTime] => [gId] => [pTime] => ) stdClass Object ( [mId] => [mAccount] => ggininder [mPasswd] => ggininder [mLastName] => ininder [mFirstName] => gg [mSex] => male [mDescription] => none [mHeight] => 178 [mWeight] => 99 [mBirthDay] => 1993-01-12 [mType] => patient [mDoctor] => 1 [lnTime] => [gId] => [pTime] => )